topic Convert YY to YYYY in QlikView

Convert YY to YYYY

jaymerry — Wed, 02 Feb 2011 15:39:15 GMT

Hello all,

I'm trying to convert year in "YY" format to "YYYY" format in my script, but it doesn't seem possible.

Have you any ideas ?

Thanks for your help,

Jaymerry

Wed, 02 Feb 2011 15:49:02 GMT

Hi,

Your date format is having year in YYYY format then you have to just write Year(Date).

Regards,

Ravi

Anonymous — Wed, 02 Feb 2011 15:56:34 GMT

It will be:
=date(date#(Year, 'YY'),'YYYY')

(Where field Year is in YY format)

jaymerry — Wed, 02 Feb 2011 15:56:56 GMT

Hi Ravi,

I have a date from a filename with this format 'MMYY' and I try to have 'YYYYMM'.

It's not really a problem for the month (left function) but for the year, I don'treally know how to do.

Thanks for your help,

Jaymerry

jaymerry — Wed, 02 Feb 2011 16:12:19 GMT

Hi all,

Thanks to your answers I have found the following script (file name : "xxxx-MMYY.xslx":

date

(date#(left(right(filename(),7),2), 'YY'),'YYYY')&left(right(filename(),9),2) as YYYYMM

Thanks for your help,

Jaymerry

Anonymous — Wed, 02 Feb 2011 19:39:05 GMT

Techically it is the same date(date#()). In your case, a more effective way (at least shorter and clearer) is:

date(date#(right(filename(),4),'MMYY'),'YYYYMM')