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, but want to use the separate Date & Time of Day fields for a calendar report. 
  • 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])