topic Date transformation in QlikView

Date transformation

cvalarcon — Mon, 03 Jun 2019 17:59:00 GMT

Hi expert

I have this field 201904 number format and I like to transform this in a date format 'YYYYMM'

I used DATE#, DATE, NUM# but without success

The final result should be 'Apr-19' , Can you help me with this ?

Thanks

dplr-rn — Mon, 03 Jun 2019 18:12:24 GMT

did you try like below ?

=Date(Date#('201904','YYYYMM'),'MMM-YY')

cvalarcon — Mon, 03 Jun 2019 18:45:45 GMT

Thanks now is ok , I forgot the last part of the exp in the DATE ,'MMM-YY')

BR