Skip to main content
Question

unable to change date to text in the report view

  • May 15, 2019 10:06 AM UTC
  • 0 replies
  • 38 views

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
This topic has been closed for replies.

Forum|alt.badge.img+17
  • Quickbase Staff
  • May 15, 2019 5:34 PM UTC
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.