Hi All,
I'm getting myself in a muddle and need some help please.
I have a List that records when a request was received (Date 1) and when that request was last Reviewed (Date 2).
A review is due every 28 days on each Item in the List.
I've tried:
1. Check if Date 2 is null
2. If yes, Add 28 days to Date 1 (Date 3)
3. Format Date 3 as yyyy-MM-dd
4. Compare Date 3 to UTCNow (less than or equal to)
5. If yes - email the team saying a review is due
6. If Date is not null, Add 28 Days to Date 2 (Date 4)
7. Format Date 4 as yyyy-MM-dd
8. Compare Date 4 to UTCNow
9. If yes - email team saying next review due
But I keep getting false positives on records that aren't due a review.
Have I overcomplicated this!?
