Convert DateTime to Date

How can I convert a DateTime value to a Date? (in DAX) For example: Date_refresh = VAR UTC_DateTimeZone = UTCNOW() VAR UTC_Date = ? Return UTC_Date How can I fill UTC_Date with the date val...

Need Help

Samarth_18

3 years ago

Hi Ad_456 ,

You could try below code:-

Date_refresh = 
VAR UTC_DateTimeZone = UTCNOW()
VAR UTC_Date = FORMAT(UTC_DateTimeZone,"mm/dd/yyyy")
Return UTC_Date

You could change data format directly from the ribbon.

Date_refresh = UTCNOW()

Forum Discussion

Convert DateTime to Date

Related content

Converting Epoch Datetime into regular datetime format

Cannot convert value #datetime to Date

Power Query convert date to datetime

MAX datetime truncates to date???

DirectQuery SQL Convert datetime to date