Skip to main content
Question

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

  • June 12, 2017
  • 0 replies
  • 34 views
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?
      This topic has been closed for replies.

      • MCFNeil
      • Registered
      • June 14, 2017
      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.
      • MCFNeil
      • Registered
      • June 14, 2017
      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
      • StephonyDBH
      • Author
      • Registered
      • June 14, 2017
      I ended up just reuploading and updating the records. Thanks!
      Terms & ConditionsAccessibility statement