Hello using Quickbase sync and I have a problem refreshing dates. It eil only refresh when I convert to US dates - it won't recognise UK format. How can I solve this?

  • 0
  • 2
  • Question
  • Updated 2 years ago

I am using sync to bring in data.  It works fine, except it won't recognise UK date formats in CSV.  I can work around by converting the CSV to US format, but this is time consuming.  Is there a way to make it recognise the UK format of dates in the CSV files?


Thanks

Joe

Photo of Joe

Joe

  • 10 Points

Posted 3 years ago

  • 0
  • 2
Photo of Matthew Neil

Matthew Neil

  • 31,678 Points 20k badge 2x thumb
Which version of sync are you using?  Google Drive or Dropbox?  

I've used google and had a similar issue that we solved for by converting the date automatically once it was in QuickBase.