Forum Discussion

Stephony_DBH_'s avatar
Stephony_DBH_
Qrew Cadet
9 years ago

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

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?

3 Replies

  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    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's avatar
    MCFNeil
    Qrew Captain
    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