ticks function(Power Automate Cloud flows)

Japanese version.

Obtains the elapsed time since January 1, 0001 for the given date and time.
The unit is 100 nanoseconds.

It has few uses, but may be used for date serial calculations in Excel.

Spec

ticks('<timestamp>')
ArgumentDefaultDescription
timestampRequired fieldSpecifies the date and time of the conversion source.

How to use

In most cases, it is used in the "value" when initializing or setting variables of type "Integer".

Click on the "Expression" tab, ticks, and the function name and () will be set in the expression field.

Specify the date of the extraction source as an argument.

If you want to use dynamic content or variables, the ,delimiter is the same.

(How to get dynamic content with expressions.)

Click on the OK button, and if the display looks like the following, the setting is complete.

You can change the function by clicking this purple icon.

For example, the serial for May 15, 2022 is calculated as follows.

add(div(sub(ticks('2022-05-15'),ticks(‘1900-1-1’)),864000000000),2)

---

Links

Date and time Functions(Power Automate Cloud flows)