Re: how to convert date format Jan 14" to "1/1/201... - Qlik Community

balasundaram · ‎2014-09-07

tell me how to covert date format Jan 14" into "1/1/2014"

MarcoWedel · ‎2014-09-07

Hi,

one solution:

=Date(Date#('Jan 14', 'MMM YY'), 'M/D/YYYY')

hope this helps

regards

Marco

PrashantSangle · ‎2014-09-07

Hi,

If it is in Date Format then try

Date(Date#(dateField,'MMM YY'),'D/M/YYYY') as newField

Or You can use MakeDate()

like

MakeDate(Year(Date#(dateField,'MMM YY')),Month(Date#(dateField,'MMM YY')),'1') as NewDateField

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

ashfaq_haseeb · ‎2014-09-07

Hi,

Assuming that you have proper date field.

Try this

Date(date#([DateField],'MMM YY'),'M/D/YYYY') as NewDate

Regards

ASHFAQ

how to convert date format Jan 14" to "1/1/2014"