Forum Discussion

PushpakumarGna1's avatar
PushpakumarGna1
Qrew Assistant Captain
6 years ago

unable to change date to text in the report view

Hi All, I am trying to change the date to text using ToText(ToFormattedText([Start_Dt],"YYYY-MM-DD")) but in the report i still see MM-DD-YYYY and while export the report into CSV , i see the same...
Formulas and functions
EvanMartinez's avatar
EvanMartinez
Moderator
6 years ago
Hi Pushpakumar,

For the ToFormattedText formula function you wouldn't want to included the - in your request. You just put in the format you want and when it displays it knows to include the - between your year, month, and day. You would just want to do:

ToFormattedText([Start_Dt],"YYYYMMDD")

That should output in text what you are looking for without needing to also add a ToText wrapped around it. I hope that is helpful.