Forum Discussion

u156531's avatar
u156531
Brass Contributor
Jul 15, 2024

Date check doesn't seem to be working

I have a date check in my Flow that doesn't seem to be working. I'm just wondering if a blank Reviewed date is considered to be less than the current date -5 days? Here is the current date formula

formatdatetime(adddays(utcNow(),-5),'MM-dd-yyyy')

.

 

  • michalkornet's avatar
    michalkornet
    Iron Contributor

    Hi u156531 If you would like to include also items where the "Reviewed date" column is empty, you can add a null check to your filter query, like this:

    Revieweddate le '<your formula>' or Revieweddate eq null

Resources