Error: Cannot convert value 'Oct' of type Text to type Date.

[giorgilomidze]

I am creating calculated column from "datetame" type  column and want to show only names of month, but i'm getting this error: Cannot convert value 'Oct' of type Text to type Date. 

Calculated Column = FORMAT(PRXGetFinishedRequestsView[REQUESTCREATETIME],"mmm")

[Phil_Seamark · Accepted solution]

Hi @giorgilomidze

Are you sure your REQUESTCREATETIME column is date time?  The error suggests it might be text already.

If it is text and only as values such as "OCT" then you can use the following calculation to convert

Calculated Column = FORMAT(DATEVALUE("1/" & PRXGetFinishedRequestsView[REQUESTCREATETIME]),"MMM")

[misskelly1020]

I am not sure if you saw my original reply............

So i have a report user in Germany. the parameter value is coming over as "okt" instead of "oct".

I'm wondering whether or not your solution will work in this case!

[misskelly1020]

are you ready for this? we are in the US and we have a customer accessing a report in Germany and the parmeter is coming across as "Okt" instead of "Oct".  Will this solution work?