Dates uploaded as 1/1/70; how to change?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I uploaded data into one of my tables that had dates. The dates all converted to 1/1/70 in Quickbase. How do I fix this?
Photo of Stephony (DBH)

Stephony (DBH)

  • 586 Points 500 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
That is a default date that is loaded in the QB API and hidden until a csv import is made and field properties have changed.  Yeah, it is a crazy weird bug that occurs randomly from my experience.
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
If you have your original import, you can either re-do it or if you have some way to pull the already existing record ID# and do a vlookup in Excel to run a mass update.

Sorry you are in this spot
Photo of Stephony (DBH)

Stephony (DBH)

  • 586 Points 500 badge 2x thumb
I ended up just reuploading and updating the records. Thanks!