Forum Discussion

ElenaLarrabee1's avatar
ElenaLarrabee1
Qrew Captain
8 years ago

Is there a way to leave the ""time"" portion of a Date/Time field blank?

I'm trying to create a formula that says "if the time portion of a date/time field is blank, then do this, if not blank, do this" but I'm noticing that the "time" portion of a date/time field is never...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
A date time field will always have a date and time.

But you can test for midnight.

IF(ToTimeOfDay([my date/time field]) = ToTimeOfDay("12:00 am"), "it is midnight")