TimeSpanDays Operator

The TimeSpanDays operator calculates the time span in full days between two date/time strings, taking a specific date/time format into account.

What	Type
Syntax	TimeSpanMonths(dateFrom, dateTo, format)
dateFrom	any
dateTo	any
format	string
Return type	int

The opertaor tries to parse both dateFrom and dateTo using the format string; then it calculates the total amount of days between the both dates, rounding the result down.

If any or both date strings cannot be parsed using the format string, the transformation process will be cancelled, throwing an appropriate exception.

For a reference of valid date/time format strings, see

• https://msdn.microsoft.com/en-us/library/vstudio/8kb3ddd4(v=vs.100).aspx (Custom Date and Time Format Strings)