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 ...
formulas
  • MarkShnier__You's avatar
    MarkShnier__You
    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.

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
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.