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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.