Discussions

Expand all | Collapse all

Date Formatting

  • 1.  Date Formatting

    Posted 16 days ago
    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
    ------------------------------


  • 2.  RE: Date Formatting

    Posted 16 days ago
    Try SearchAndReplace(ToText([Date Field]), "-", "/")

    ------------------------------
    Paul Peterson
    ------------------------------



  • 3.  RE: Date Formatting

    Posted 15 days ago
    Thanks Paul:

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

    Dirk

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



  • 4.  RE: Date Formatting

    Posted 14 days ago
    Paul:

    I think I have it.  Report Formula.

    Thank you,

    Dirk

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