topic Re: Date Conversion issue in QlikView

Date Conversion issue

Fri, 03 Apr 2015 09:31:30 GMT

Hi Community,

I am looking to convert two dates to link them. One date is in 'MMM-YYYY' format, i want to keep this format. The second date im pulling from excel is in mmm-yy format(Checked it form Format Cells- Custom). Any help on how i can convert it into MMM-YYYY. Ive tried Date#(Date#(TransMonthYr,'mmm-yy'), 'MMM-YYYY'). Doesnt seem to be working, any hints ?

Re: Date Conversion issue

sujeetsingh — Fri, 03 Apr 2015 09:39:49 GMT

The best way is convert both the dates as same format

Date(Date#(TransMonthYr,'mmm-yy'), 'MMM-YYYY')

Re: Date Conversion issue

PrashantSangle — Fri, 03 Apr 2015 09:46:29 GMT

Hi,

Date(Date#(TransMonthYr,'MMM-YY'), 'MMM-YYYY').

Regards