Skip to main content
Question

Exporting reports with converted date

  • July 25, 2021
  • 0 replies
  • 31 views

Hi
Is there a way to export reports from QB with a converted date format dd-mm-yyyy?

Currently the report shows -
Month Name - dd - yyyy

But when I export the Report it converts the date to mm-dd-yyyy


------------------------------
Jessica Matenga
------------------------------
This topic has been closed for replies.

  • Quickbase Alumni
  • July 26, 2021
You could build the date you want as a text field formula to achieve this I think. Since you want text in the date this might be the only way. If I am understanding you right you would like it to be exported as JUL-28-2021.

Forum|alt.badge.img+14
You can also change your excel settings. If you highlight your date column and format the date properties (easy shortcut is to click the little arrow on the bottom right of the 'Number' section on the Home Tab), you have multiple options of how to show the date. I think you can either select a format with the entire month name, date, year, or also abbreviated month (but no year)

------------------------------
Mike Tamoush
------------------------------