Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,'')
This?
=If(DateType = 'Open Date', Date(CanonicalDate, 'MMM-DD-YYYY'), Null())
This?
=If(DateType = 'Open Date', Date(CanonicalDate, 'MMM-DD-YYYY'), Null())