Solved: Changing date from 01-Jan-21(General) to Date form... - Qlik Community

priya__patel · ‎2021-08-23

Hi, I have dates in the format "01-Jan-21" which doesn't fit any given date formats in Qlik to map it to. Any ideas on how I can convert this to a date format supported in Qlik? Thanks in advance!

MayilVahanan · ‎2021-08-24

Hi

If your dates are in text format, try with date# function like below

=Date(Date#('01-Jan-21', 'DD-MMM-YY'),'DD/MM/YYYY')

- it gives 01/01/2021

You can change the date format based on ur requirement

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

MayilVahanan · ‎2021-08-24

Hi

If your dates are in text format, try with date# function like below

=Date(Date#('01-Jan-21', 'DD-MMM-YY'),'DD/MM/YYYY')

- it gives 01/01/2021

You can change the date format based on ur requirement

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

Changing date from 01-Jan-21(General) to Date format