Forum Discussion

DavidLeech's avatar
DavidLeech
Qrew Member
3 months ago

Formula Date Time Will not Accept Null Condition

Hi all -  I have a dataset importing into QuickBase but the dates arrive in EPOCH time (milliseconds since 1/1/1970). These import into the field dtmDateCompleted, a numeric field.  I am trying to ...
  • MarkShnier__You's avatar
    3 months ago

    Numeric fields typically default to treating blank as zero. Go to the field properties for [dtmDateCompleted] and deselelct that option.  Then blank / empty will be treated as null.