1 of 1 people found this helpful
As YD said, I would convert the date to a string, so str([date]).
Then you could apply a regular expression like REGEXP_REPLACE to bring your data into shape.
If I had "YYYY-MM-DD" and I would want to transfor it to "DD-MM-YY" I would use :
Let me know if that helps.
Thanks for the question and feedback. We are thinking about about how to give users the ability to convert between different date formats. We would love to get a sense of your use cases, could you please submit an idea and describe some of the scenarios you want to address?
Thanks for responding - we appreciate the attention you and the team give to community feedback.
Since Joshua has already created an idea with some great use cases, I've just added some details on my original date format display use case to that, and voted for it.
Happy to provide more detail if required.
I had to write this formula in a calculated field to produce a string which would export as a string not as a date with slashes.
datStartDate is a date field from a database which Prep recgonizes as a date. You convert each Month, Day, Year to integers, make them strings, pad with 0's for the one digit days and months.
Str(Year([datStartDate])) + "-" + RIGHT("0" + Str(Month([datStartDate])),2) + "-" + RIGHT("0" + Str(Day([datStartDate])),2)