Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Springbok43
New Member

How to change a date field from date time to a date

I have a date field that has the short date plus 0:00 on the end when I export to Excel.  I did go to the relationships editor and change the type of the field to just date but when I export the data from the visual I still get that 0:00 in the field.  Because of this I am having trouble calculating the number of days in this field from Today()

Springbok43_0-1679347510844.png

Is there anything I can do to change this date type so that I can use it in an aging calculated column?

3 REPLIES 3
vicky_
Super User
Super User

You can try add a new column with the formula DateOnly = INT(Deadline Date) and change the column type to Date, or go into PowerQuery and change the type there. When you load, it will default to show all times as 12am, but you can then simply change the format.

Thanks Vicky.

I am still getting an error when I try and use it in a viz:

OLE DB or ODBC error: Local evaluation of Table.Join or Table.NestedJoin with key equality comparers is not supported

based on the error message that is a different problem. This thread suggests that the issue is using Direct Query mode - so either change mode or use a different way to merge tables.

Helpful resources

Announcements
October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.