Skip to main content

Notifications

Power Automate - General Discussion
Answered

How to Subtract two dates and get the result in an integer to to compare with integer value?

(0) ShareShare
ReportReport
Posted on by 41

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.

Categories:
  • Verified answer
    RobElliott Profile Picture
    RobElliott 9,997 on at
    Re: How to Subtract two dates and get the result in an integer to to compare with integer value?

    Hi @WaleedBinAfzal , you need to have a couple of Compose controls, one to get today's date in the date format you want, and the second to calculate 7 days ago in the same date format. Then you have a Condition control: if SubmittedDate is greater than or equal to the output of 7 days ago AND Submitted date is less than or equal to the output of the Today compose then.....

    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.

     

    1-Compose controls and expression1-Compose controls and expression2-Condition2-Condition

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard