NowDatetime = NOW() Measure But only return DD/MM/YYYY format?

Question

Hello everyone!&nbsp;I have a measure which returns todays date for my report however it gives me a full time stamp including the hours of the day like so:&nbsp;11/12/2019 09:50 AM&nbsp;while I only want:&nbsp;11/12/2019&nbsp;What can I change on my measure to do this?&nbsp;Thanks

sivamani · Accepted Answer

Anonymous&nbsp;,&nbsp;Please do try this -NowDatetime =&nbsp;Format(NOW(), "DD/MM/YYYY") or&nbsp;NowDatetime =&nbsp;Format(TODAY(), "DD/MM/YYYY")&nbsp;Thanks,Siva

Forum Discussion

NowDatetime = NOW() Measure But only return DD/MM/YYYY format?

1 Reply

Related content

Date Formats - MM/DD/YYYY to DD/MM/YYYY

how to change date format --- mm-dd-yyyy to dd-mm-yyyy in power bi

Date issue - dd/mm/yyyy vs mm/dd/yyyy

unable to change date format mm/dd/yyyy to dd/mm/yyyy

How to configure power query date as dd/mm/yyyy instead of mm/dd/yyyy