How to change the datetime format to just have date for conditions in powerautomate
I am trying to create a flow that reminds the owner of the order (Dynamics 365) by using a date time field, however the date time field is showing time. I would explain the flow that I created below (I am not sure if this is the correct way that I did it or if there are more optimal ways to go with this problem)
I first initialized a variable that would get the time now and add an additional 7 days to it.
and then afterwards i used a list record which gives out active orders. (This is the part where I think i can improve it by using a filter query to just check the datetime field that would be coming up in the next 7 days only however I do not know the exact query to use)
After getting the list I use this condition where it uses the variable i initialized at the start to check for the datetime field however due to it being a date time field its not matching, i checked it using a compose and it showed up like this.
Below you could see that the datetime field has time on it as well, i was wondering how i could just leave the date field on it.
Or if you have better ideas to make it more optimized like just adding something on the filter query to prevent listing a lot of active orders that would be the best. Thanks guys