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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
SI_NY02
Contributor III
Contributor III

Change to date format as part of statement

I have the following if statement, which returns the correct answer, but I need it to be in date format "MMM-DD-YYYY".  How do I add that? 

=if(DateType = 'Open Date', CanonicalDate,'')

Labels (2)
1 Solution

Accepted Solutions
BrunPierre
Partner - Master II
Partner - Master II

This?

=If(DateType = 'Open Date', Date(CanonicalDate, 'MMM-DD-YYYY'), Null())

View solution in original post

1 Reply
BrunPierre
Partner - Master II
Partner - Master II

This?

=If(DateType = 'Open Date', Date(CanonicalDate, 'MMM-DD-YYYY'), Null())