The number of minutes between datetimes.

Minutes = SRP_DateTime("MinuteSpan", FromDateTime, ToDateTime, Fractional)

Returns

The number of minutes between two datetimes

Parameters

ParameterDescription
FromDateTimeA starting datetime in OI internal format. (REQUIRED)
ToDateTimeAn ending datetime in OI internal format. (REQUIRED)
FractionalDetermines if the span should be in whole minutes or fractional minutes. (OPTIONAL)

Remarks

The "MinuteSpan" service calculates the number of minutes between two datetimes. The result will be positive if the starting datetime comes before the ending datetime and negative if the ending datetime comes first.

If Fractional is set to 1, which is the default, you will get a decimal number if the seconds are not the same for each datetime. If you want whole minutes only, set Fractional to 0.

Examples

// Get the number of minutes between two datetimes
From = SRP_DateTime("Parse", "Monday, December 8, 1941 at 7:51:43am", "DDD, MMMM D, YYYY at h:mm:sstt")
To = SRP_DateTime("Parse", "Thursday, March 30, 1978 at 12:41:08pm", "DDD, MMMM D, YYYY at h:mm:sstt")
Minutes = SRP_DateTime("MinuteSpan", From, To)

// Get the number of whole minutes 
Minutes = SRP_DateTime("MinuteSpan", From, To, 0)
  • No labels