cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alielzaa Regular Visitor
Regular Visitor

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
SivaMani Senior Member
Senior Member

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

@alielzaa ,

 

Please do try this -

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

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

 

Thanks,

Siva

View solution in original post

1 REPLY 1
SivaMani Senior Member
Senior Member

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

@alielzaa ,

 

Please do try this -

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

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

 

Thanks,

Siva

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors