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 format.

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

Thanks in advance
Pushpakumar
Formulas and functions
  • EvanMartinez's avatar
    EvanMartinez
    Quickbase Staff
    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.