TimeSpanDays Operator - Haufe-Lexware/haufe.no-frills-transformation GitHub Wiki
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)