Skip to main content
Question

Separate Date/Time Field to Date Field and Time Field

  • August 10, 2017
  • 0 replies
  • 76 views
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. 
      This topic has been closed for replies.

      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])
        Terms & ConditionsAccessibility statement