Skip to main content
Question

Date Formatting

  • July 22, 2020
  • 0 replies
  • 49 views

Forum|alt.badge.img+8
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
------------------------------

  • Quickbase Alumni
  • July 22, 2020
Try SearchAndReplace(ToText([Date Field]), "-", "/")

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