web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate Convert dateDifference...

Power Automate

Unanswered

Convert dateDifference to days

(0) Share

Report

Report

Posted on by Tango

1,164

Hi,

I have an output of -20:58:33.2982132 which is the result of running dateDifference from now to a Due Date field.

dateDifference(utcNow(),item()['DueDate'])

How do I convert this to days only? (I've tried split and substring functions but cant get it right)

Thanks in advance

Todd

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

v-bofeng-msft on at

Like (0)

Report
Re: Convert dateDifference to days

Hi @Tango ,

Please try

div(sub(ticks(utcNow()),ticks(item()['DueDate'])),864000000000)

Best Regards,
Bof

Was this reply helpful? Yes No
jdavisp3 6 on at

Like (2)

Report
Re: Convert dateDifference to days

The answers aren't really saying how to do this with dateDifference. You can use int and split:
int(split(dateDifference(utcNow(), item()['DueDate']), '.')[0])

Was this reply helpful? Yes No
tbartman 3 on at

Like (0)

Report

Re: Convert dateDifference to days

Thank you jdavisp3 - that did the trick!
concat(int(split(dateDifference(utcNow(), '2025-02-28'), '.')[0]), ' Days Remaining')

Was this reply helpful? Yes No

Join the conversation