topic Re: Convert month-year to date in QlikView

Convert month-year to date

linoyel — Wed, 06 Aug 2014 14:46:39 GMT

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!

Re: Convert month-year to date

PrashantSangle — Wed, 06 Aug 2014 14:47:35 GMT

Hi,

Use makeDate()

It will help you

For details check in help menu.

Regards,

Re: Convert month-year to date

agomes1971 — Wed, 06 Aug 2014 14:51:04 GMT

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.pdf

Regards

André Gomes

Re: Convert month-year to date

linoyel — Wed, 06 Aug 2014 14:52:10 GMT

COOL!!!!

Thank you

Re: Convert month-year to date

its_anandrjs — Wed, 06 Aug 2014 14:52:46 GMT

Convert your field this way

Load

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

From Location;

Re: Convert month-year to date

maxgro — Wed, 06 Aug 2014 14:53:57 GMT

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

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