Discussions

Expand all | Collapse all

Separate Date/Time Field to Date Field and Time Field

  • 1.  Separate Date/Time Field to Date Field and Time Field

    Posted 08-10-2017 19:10
    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. 


  • 2.  RE: Separate Date/Time Field to Date Field and Time Field

    Posted 08-10-2017 19:59
    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])


  • 3.  RE: Separate Date/Time Field to Date Field and Time Field

    Posted 08-10-2017 20:01
    Thank you!