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

[alielzaa]

Hello everyone!

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:

11/12/2019 09:50 AM

while I only want:

11/12/2019

What can I change on my measure to do this?

Thanks

[SivaMani · Accepted solution]

@alielzaa ,

Please do try this -

NowDatetime = Format(NOW(), "DD/MM/YYYY") or 

NowDatetime = Format(TODAY(), "DD/MM/YYYY")

Thanks,

Siva