You’re offline. This is a read only version of the page.
Hi,
i need help on the day's comparison between 2 different dates which will be starting from middle of months in the flow.
Scenario: need the charge i have to give between 2 dates
charges Are:
1)Jan to March -300
2) April to July -200
If my invoice comes between 2 charges, that is date > 15(means after 15 days of month) i need to charge from second consequent charge amount.
example 1: If the invoice is generated from March 16 - June 17 Then the amount charged is 600(3* 200)
example 2: If the invoice is generated from March 15(or <) - June 17 Then the amount charged is 700(2* 200) +(1*300)
APPRICIATE YOUR HELP....
example 1: If the invoice is generated from FEB 15(or <) - June 17 Then the amount charged is 1000(2* 200) +(2*300)
Where i use tick function then i get days , is there any way again to get months from days
Hey @Ashwinreddy
You can use the tick method to find the days difference between two dates. Then by the value you get at the end you can calculate the charges.
Giving you link below to calculate date difference:
https://debajmecrm.com/how-to-compare-dates-in-power-automate/
https://debajmecrm.com/how-to-calculate-difference-between-two-dates-in-power-automate/
https://sympmarc.com/2021/02/22/calculate-the-difference-between-two-dates-in-power-automate/
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
Share
Report
All responses (
Answers (