Forum Discussion

BrittanyBrittan's avatar
BrittanyBrittan
Qrew Trainee
8 years ago

Separate Date/Time Field to Date Field and Time Field

Our Date/Time field is inputted by mass import. Is there a formula I can use to separate the Date/Time field into 2 fields - Date & Time of Day?  I like the combined Date/Time field for table reports...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
No problem.

One of the fields will be a formula Time Of Day field type

ToTimeOfDay([my date/time field])


The other will be a formula Date field type

ToDate([my date/time field])
  • BrittanyBrittan's avatar
    BrittanyBrittan
    Qrew Trainee
    8 years ago
    Thank you!