Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to reformat date

Hello,

I have a date field already defined converting from Jan 1, 2000 10:38:50 AM EST to 1/1/2000

But I am looking to create a MonthYear to then take that number and change it to Jan 2000, while still keeping the 1/1/2000 field as well. How would I do that? Here's what I have so far.

[First Discovered],

     Date(Floor(TimeStamp#(SubField([First Discovered], ' E', 1), 'MMM DD, YYYY hh:mm:ss'))) as First_Discovered,

Thanks

1 Reply
sunny_talwar

May be this

Date(MonthStart(Floor(TimeStamp#(SubField([First Discovered], ' E', 1), 'MMM DD, YYYY hh:mm:ss'))), 'MMM YYYY') as MonthYear,