Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
cvalarcon
Contributor III
Contributor III

Date transformation

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

 

 

1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

did you try like below ?

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

View solution in original post

2 Replies
dplr-rn
Partner - Master III
Partner - Master III

did you try like below ?

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

cvalarcon
Contributor III
Contributor III
Author

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

BR