=DATETIMEMERGE
The DATETIMEMERGE function combines a date and a time into a single date/time value. Commonly used to merge a separate date field and time field into one unified timestamp.
Syntax
Section titled “Syntax”=DATETIMEMERGE(DateValue; TimeValue)Parameters
Section titled “Parameters”-
DateValue
- The date component to use in the merged result.
-
TimeValue
- The time component to use in the merged result.
How It Works
Section titled “How It Works”-
Takes the calendar date from DateValue and the clock time from TimeValue.
-
Produces a single date/time value combining both components.
-
Supports ISO date formats for input and output.
Usage Notes
Section titled “Usage Notes”-
Ensure both inputs are valid date or time values.
-
Formula functions are case sensitive and must be in all caps.
-
Useful for scheduling, logging events, or combining separate fields into one timestamp.
Example
Section titled “Example”=DATETIMEMERGE(5/24/2023; 12:37 PM)// Returns: 5/24/2023 12:37 PM- Here, the date 5/24/2023 and the time 12:37 PM are merged into a single date/time value in a standard readable format.
Example Using ISO Date Formats
Section titled “Example Using ISO Date Formats”=DATETIMEMERGE(2023-05-24T09:48:00; 2024-06-27T12:37:00)// Returns: 2023-05-24T12:37:00Keywords
Section titled “Keywords”DATETIMEMERGE, merge date and time, combine date time, unified timestamp, ISO date format, workflow formulas, date calculation, scheduling, event logging, process field dates