In this blog, we are going to see how to check if the due date is today.
The most important thing in the date comparison is the Date Format. If it is not matching the right date format then it will end up in error.
The SharePoint field "Due Date" has the value in "M/d/yyyy" format, so the utcNow() date should also be in the same format, only then will we be able to compare it.
Ex: If the date is "07/06/2021", the "MM/dd/yyyy" format will give you the result as "07/06/2021". But if the date format is set to "M/d/yyyy" you will get the date as "7/6/2021". That makes the difference.
The Formula in Filter Query for Due Date is equal to the current date and should be as shown below,
![Checking the Date in Filter Query within Power Automate Flow]()
If you like this post, please do like, share, and comment.