Date time conversion function not working as expected

[#1]

Hi folks,

One of my qvd having 32 bit integer field with date in the format YYYYMM . I have loaded that column by converting it into date like Date#(Date_field) as NewDate

When i am trying to display it in chart dimension as Jan 2015 , Feb 2015 , etc., using expression MonthName(NewDate) it is throwing error. Is there any problem with my conversion Date# in the load script ? Please help.

TIA

James

[MindaugasBacius · Accepted solution]

Try convert the date like this:

Date(Date#(Date_field, 'YYYYMM'), 'YYYY-MM-DD') as NewDate

Then date functions start working.

[#3]

Thanks mindaugasbacius‌ ! Works Well !!

-James