Forum Discussion
4 Replies
Sort By
- QuickBaseCoachDQrew CaptainA 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") - ElenaLarrabee1Qrew CaptainAh, I see. Shoot, I thought about doing that, but occasionally the time actually will be midnight and I won't want the formula to treat it as a blank value.
- MCFNeilQrew CaptainThe field type of 'Date/Time' must have a time, thus even if you leave it blank the time is defaulted.
It is usually best to have those fields separated on the data entry portion, and then have them combined later if needed.
If its possible for you, I'd recommend making a 'date' field and a 'time of day' field. Then you can easily create the formula field to default to what you need.
Generally speaking its always easier to combine, then to separate.
i.e. First Name & Last Name as two separate fields, can always be combined to one, but its harder to separate full name into its components later. - ElenaLarrabee1Qrew CaptainMakes sense, thanks!