cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

How to subtract two dates and get the result in integer to compare with integer?

Hi,

I have an entity in Microsoft Dynamics 365 CRM in which I have a submission date. What I want is to make an assistant card in Dynamics 365 CRM using Microsoft Flow that will be triggered before 7 days to the Submission date. 

I don't know how I can subtract two dates and get the result in an integer which I can compare with an integer value.

The condition will be something like this.

If((Submission Date - Current Date) <= 7 Days)

then show the assistant card,

Else do nothing.

 

I don't know how to achieve this in Microsoft Flow.

 

Any help or suggestion would be highly appreciable.

 

Thanks,

Waleed bin Afzal.

1 REPLY 1
Highlighted
Super User III
Super User III

Re: How to subtract two dates and get the result in integer to compare with integer?

Hi, see the response to your question on this at https://powerusers.microsoft.com/t5/General-Flow-Discussion/How-to-Subtract-two-dates-and-get-the-re....?

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

 

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (4,675)