Hello, I am wondering if there is a way to make Specify recognize different date formats? For example, it is set up as Year/Month/Day, but in Excel it formats it as Year-Month-Day. Is there a way to fix it so that I don’t have to fix all of the dates one at a time?
Hey! You can change the date format in your database’s remote preferences file.
As for excel changing the values, that is annoying and something I also deal with. It’s an unfortunate feature that has nothing to do with specify and everything to do with the way Excel handles date values / imports data from CSVs. You’ll notice if you open the CSV exported by specify in a text editor or CSV reader like ModernCSV that the values don’t change.
One thing you can do to combat this is configuring your exports of date values in 3 separate fields (Year, Month, Day) in the query builder. This is not ideal but does keep data from getting mangled or ever being ambiguous.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.