Returns a table of information representing the time interval between two Date Time values.
DateTimeSpan([DateTime1],[DateTime2],[Culture Name])
Where:
DateTime1 is the earliest DateTime.
DateTime2 is the latest DateTime.
Culture Name (optional) is the name of the culture to use in the format languageCode-regionCode. For example en-us.
| Rule | Result | Meaning |
|---|---|---|
| DateTimeSpan("09/16/2017 11:30:21","03/29/2019 11:30:04") | {"Days","Hours","Minutes","Seconds","Milliseconds","TotalDays","TotalHours", "TotalMinutes","TotalSeconds","TotalMilliseconds"; 558,23,59,43,624,558.99,13415.99,804959.72,48297583.62,48297583624.68} | This is the Array that will be created with information representing the time interval between two Date Time values. |
| DateTimeSpan(DWVariableThen,DWVariableNow) | {"Days","Hours","Minutes","Seconds","Milliseconds","TotalDays","TotalHours", "TotalMinutes","TotalSeconds","TotalMilliseconds"; 558,23,59,43,624,558.99,13415.99,804959.72,48297583.62,48297583624.68} | This is the Array that will be created with information representing the time interval between two Date Time values. |
| DateTimeSpan("09/16/2017 11:30:21","03/29/2019 11:30:04","en-us") | {"Days","Hours","Minutes","Seconds","Milliseconds","TotalDays","TotalHours", "TotalMinutes","TotalSeconds","TotalMilliseconds"; 558,23,59,43,624,558.99,13415.99,804959.72,48297583.62,48297583624.68} | This is the Array that will be created with information representing the time interval between two Date Time values.
Including the Culture Name will ensure the dates are parsed as US date times, regardless of the culture of the machine it is being run on. |