Can't get formateDateTime to work with Ticks

(0) Share

Report

Posted on by DavidMullett

Hi there,

I have a simple flow which takes a StartDate and an EndDate both of which are pulled from a list in yyyy-MM-dd format.

When I add this to calculate the difference in days between the dates using the ticks method it keeps saying "The datetime string must match ISO 8601 format.'."

Here is the line I'm using:

div(sub(ticks(formatDateTime('StartDate','yyyyMMdd')),ticks(formatDateTime('EndDate','yyyyMMdd')),864000000000))

Not sure what I'm missing here?

Thanks

David

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

fchopo 8,003 Moderator on at

Like (1)

Report
Hi @DavidMullett

Could you use the following expression?:

div(sub(ticks(formatDateTime('StartDate','yyyy-MM-dd')),ticks(formatDateTime('EndDate','yyyy-MM-dd')),864000000000))

You should use ISO 8601 to make those datetime calculations.

Hope it helps!

Ferran

Was this reply helpful? Yes No
DavidMullett 51 on at

Like (0)

Report

Thanks Ferran,

Unfortunately I had attempted that format. I copied your expression in just in case but still throws this error. I've attached a shot showing what the varibles are going in as well.

Thanks
David

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (0)

Report
Hi @DavidMullett :

Please try:

div( sub( ticks(formatDateTime(variables('EndDate'))), ticks(formatDateTime(variables('StartDate'))) ), 864000000000)

Result:

Best Regards,

Bof

Was this reply helpful? Yes No
DavidMullett 51 on at

Like (0)

Report

Brilliant, thanks! That worked a treat.

Was this reply helpful? Yes No