Convert month-year to date

[linoyel]

Hey!

I have a table with MonthYear column in the format like "Aug-2014".

In order to link it to my calendar table (all other tables are linked to the calendar by DateNum), I need to present my MonthYear column in date format. I don't care if "Aug-2014" will be presented like "2014-08-01".

Please help!

[PrashantSangle · Accepted solution]

Hi,

Use makeDate()

It will help you

For details check in help menu.

Regards,

[agomes1971]

Yes it's true use:

TIP 3: USE THE MAKEDATE FUNCTION

If your date is stored in several fields, e.g. one field for year, a second for month and a third

for day, you should use the MakeDate function to create a proper date serial number for the

specified day:

MakeDate( Year, Month, Day ) as Date

Please see this pdf: http://community.qlik.com/servlet/JiveServlet/previewBody/3102-102-4-4191/DateFields-TechBrief-US_v2...

Regards

André Gomes

[linoyel]

COOL!!!!

Thank you

[its_anandrjs]

Convert your field this way

Load

Year(MonthYear )&'-'&Num(Month(MonthYear)) as DateNum

From Location;

[maxgro]

=date(date#('Aug-2014', 'MMM-YYYY'), 'YYYY-MM-DD')

=date(date#(YourField, 'MMM-YYYY'), 'YYYY-MM-DD')