Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
amrutha_sathish
Contributor II
Contributor II

Converting a Date Format to another

I have a field Named Month in the format of 202304 (YearMonth).

So how do i convert it into the format 'Apr-23'.

Thanks in advance.

Labels (3)
2 Solutions

Accepted Solutions
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Something along these lines:

Date(date#(OldMonth, 'YYYYMM'), 'MMM-YY')

 

View solution in original post

BrunPierre
Partner - Master
Partner - Master

One way could be this.

Date(Date#(YearMonthField,'YYYYMM'),'MMM-YY')

View solution in original post

6 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Something along these lines:

Date(date#(OldMonth, 'YYYYMM'), 'MMM-YY')

 

BrunPierre
Partner - Master
Partner - Master

One way could be this.

Date(Date#(YearMonthField,'YYYYMM'),'MMM-YY')

amrutha_sathish
Contributor II
Contributor II
Author

Thank you! It worked!! 😊

amrutha_sathish
Contributor II
Contributor II
Author

Thank you! It worked 🤗

simsa
Contributor III
Contributor III

Date(Date#('202303','YYYYMM'),'MMM-YY')

simsa_0-1688657843274.png