unable to change date to text in the report view

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • Answered
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 format.

Can someone let me know how can i change to YYYY-MM-DD when i get exported to CSV?

Thanks in advance
Pushpakumar
Photo of Pushpakumar Gnanadurai

Posted 2 months ago

  • 0
  • 1
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 12,348 Points 10k badge 2x thumb
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.