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 f...
Forum Discussion
Hi Dirk,
In the past I have done this into a separate formula text field by using the SearchAndReplace function to search a field for any instance where a - appears and replacing it with a /. That way when you export a report you can specifically export that field and any dates that were captured in the other format will get changed and any dates that are already in the right format should be ignored and passed over correctly.
SearchAndReplace formula reference
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------
In the past I have done this into a separate formula text field by using the SearchAndReplace function to search a field for any instance where a - appears and replacing it with a /. That way when you export a report you can specifically export that field and any dates that were captured in the other format will get changed and any dates that are already in the right format should be ignored and passed over correctly.
SearchAndReplace formula reference
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------