Discussions

Expand all | Collapse all

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

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

    Posted 06-12-2017 15:49
    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?


  • 2.  RE: Dates uploaded as 1/1/70; how to change?

    Posted 06-14-2017 03:00
    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.


  • 3.  RE: Dates uploaded as 1/1/70; how to change?

    Posted 06-14-2017 03:03
    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


  • 4.  RE: Dates uploaded as 1/1/70; how to change?

    Posted 06-14-2017 15:02
    I ended up just reuploading and updating the records. Thanks!