Date columns is equal to 6 months old (182 days) ?

(0) Share

Report

Posted on by sudosaurus

1,599 Super User 2024 Season 1

Hello,

In the above condition, I am checking two things. A status value and a date. It is the date that I am having issues with.

Essentially the flow runs daily and needs to check whether the PostProgrammeCompletionDate is equal to or older than 6 months (182 days).

This is what I have currently, however the glue doesn't appear to be sticking!

formatDateTime(item()?['PostProgrammeCompletionDate'], 'dd/MM/yyyy')

is less or equal to

lessOrEquals(formatDateTime(item()?['PostProgrammeCompletionDate'], 'dd/MM/yyyy'), formatDateTime(addToTime(utcNow(), -6, 'Month'), 'dd/MM/yyyy'))

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

sudosaurus 1,599 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Solved it!

addDays(items('Apply_to_each')?['PostProgrammeCompletionDate'], 182)

is less or equal to

utcNow()

Was this reply helpful? Yes No