Forum Discussion

DirkRuana's avatar
DirkRuana
Qrew Captain
5 years ago

Date Formatting

Hello:

I am just trying to change date formats in Quickbase.

Normally I would have:

07-22-2020

Would like to change the hyphens to backslash:

07/22/2020

I am outputting a CSV file for import into an accounting program.  Accounting program does not recognize hyphens.

I am hoping this is a simple fix.

Thank you,

Dirk

------------------------------
Dirk Ruana
------------------------------
  • PaulPeterson1's avatar
    PaulPeterson1
    Qrew Assistant Captain
    Try SearchAndReplace(ToText([Date Field]), "-", "/")

    ------------------------------
    Paul Peterson
    ------------------------------
    • DirkRuana's avatar
      DirkRuana
      Qrew Captain
      Thanks Paul:

      So.... I would create txt formula field?  Then use suggested formula?

      Dirk

      ------------------------------
      Dirk Ruana
      ------------------------------
      • DirkRuana's avatar
        DirkRuana
        Qrew Captain
        Paul:

        I think I have it.  Report Formula.

        Thank you,

        Dirk

        ------------------------------
        Dirk Ruana
        ------------------------------