Add a condition to check a date field is less than 3 months of the process execution time

(0) Share

Report

Posted on by CrashQ

Hi Guys,

I am new to making cloud flows and am I struggling to get a condition working in my cloud flow.

I have got the value for the current time and date of the field as below which is fine, however, I am trying to make a condition to check a date field is less than 3 months of the process execution time, and if so fire off an email. I am using my variable as the value and saying if this is less than and then using my fx condition in the image below and then start creating an email

Obtained the value of the date and time being used in the field

Then making an fx expression to check if the date difference of today(utc now) and check if the adddays is 90, pretty sure this is not correct way of doing this, asking for help on how i can achieve this?

I did achieve this in a workflow condition, however this keeps creating multiple of the same email.

I am trying to create the same condition in my workflow, but in a cloud flow condition.

I hope someone can help go in the right direction please?

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Jamesp2793

To get the date for 90 days from today, you can use the expression:
addDays(utcNow(),90)

Can you share more details on where the date value in the variable is coming from? To compare dates in Power Automate, the date format needs to be yyyy-MM-ddThh:mm:ss

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Jamesp2793

Use this expression to compare days difference b/w dates

add(div(sub(ticks(adddays(utcnow(),90)),ticks(utcnow())),864000000000),2)

Refer here for more details: https://manueltgomes.com/reference/powerautomate-function-reference/power-automate-ticks-function/

Was this reply helpful? Yes No
CrashQ 10 on at

Like (0)

Report
Copy link

Link copied!

Hi Both,

Thank you for the replies, this is the variable i am using for the date field in crm

Was this reply helpful? Yes No
Verified answer

Chriddle 8,672 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
The value of this variable is not a valid date string.
You might convert it with:
parseDateTime('12/07/2023 00:00', 'es-es', 'dd/MM/yyyy hh:mm')

Was this reply helpful? Yes No
CrashQ 10 on at

Like (0)

Report
Copy link

Link copied!

thanks for the reply chriddle, i have managed to get it working now and for the cloud flow to fire off when the date is in within a 3 months period. The only issue i have now is that it is creating multiple emails which i'll have to look into.

Thanks for you suggestion.

Was this reply helpful? Yes No