Discussions

Expand all | Collapse all

unable to change date to text in the report view

  • 1.  unable to change date to text in the report view

    Posted 05-15-2019 06:06
    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


  • 2.  RE: unable to change date to text in the report view

    Top
    Contributor
    Posted 05-15-2019 13:34
    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.