Separate Date/Time Field to Date Field and Time Field

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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. 
Photo of Brittany

Brittany

  • 210 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
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])
Photo of Brittany

Brittany

  • 210 Points 100 badge 2x thumb
Thank you!