web

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

Power Platform CommunityForums Power Automate - Building Flows Convert dateDifference...

Power Automate - Building Flows

Answered

Convert dateDifference to days

(0) Share

Report

Report

Posted on by Tango

1,159

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

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

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 797 Super User 2025 Season 2

#2

Tomac 425 Moderator

#3

developerAJ 319

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans