Format date error

[Rince91]

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?

[Gokul]

make sure that  your data type is in date format 

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

[Rince91]

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