Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
mikegauntlett
Contributor III
Contributor III

Date conversion Jan 2018 to 2018-01-01

Hi I have a Field in my data that is populated by Jan 18, as the Month and Year.

Is there any way to convert it into 'yyyy MM dd' ?

I have looked at inline tables but there are to many variables.

Many Thanks

4 Replies
Ivan_Bozov
Luminary
Luminary

Hello, maybe this in the script:

Date(Date#(YourDateField, 'MMM YYYY'), 'YYYY.MM.DD') AS YourDateField

vizmind.eu
sunny_talwar

shraddha_g
Partner - Master III
Partner - Master III

Try Date(Date#(YourDateField, 'MMM YYYY'), 'YYYY-MM-DD')

mikegauntlett
Contributor III
Contributor III
Author

Thanks Ivan, that worked