Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
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
Partner - Master

This?

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

View solution in original post

1 Reply
BrunPierre
Partner - Master
Partner - Master

This?

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