Syntax
ticks('<timestamp>')Examples
div(sub(ticks(variables('end')), ticks(variables('start'))), 864000000000)Whole days between two dates
Maker notes
- One day is 864,000,000,000 ticks.
Returns a timestamp as ticks: 100-nanosecond steps since 1 January 0001.
ticks('<timestamp>')div(sub(ticks(variables('end')), ticks(variables('start'))), 864000000000)Whole days between two dates