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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Rince91
Helper I
Helper I

Format date error

Hey,

 

I have an open time for tickets we recieve formated like the below:

 

OPEN_TIME

01/10/2017 00:07:07

 

I then need this formatted as Month and Year. I have created a new column with the below formula:

 

Open_Month = FORMAT(ServiceReview[OPEN_TIME],"mmmm-yy")

 

However for some date it works fine, for the above date it prints October 2018. Should be 2017, any ideas what is causing this issue?

 

2 REPLIES 2
Gokul
Helper IV
Helper IV

make sure that  your data type is in date format 

ServiceReview[OPEN_TIME] is of type date so that u can get correct value..

Yep i definitely have the original columns formated correctly as Date under the modeling tab.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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