Flow Designer Valid to on Tomorrow does not filter the right entries

[ozgurD]

Hello,

I currently have a problem with the Valid to on Tomorrow (specifically on the “on Tomorrow Operator):

I want to filter out all KB articles that have the valid to date of tomorrow, this flow is triggered every day in the morning but for some reason it always filters me not the valid to tomorrow but the KB articles where the valid to is on the same day, e.g. execution of the flow: 27.08.2024 then it should find all KB articles that have a valid to from 28.08 but it finds the kb articles that have a valid to from 27.08.

Tests:
I have already checked that the flow is triggered at the right time. I have also entered a fixed date instead of Valid to on tomorrow for test purposes, i.e. valid to on 29.08.2024, here he then found the correct kb article, so it is not the trigger but actually the “Tomorrow”.

The other conditions also always match

Thank you for your help 

[Mark Manders · Accepted solution]

Wouldn't it be better, looking at the requirement, to give the author more time? Like provide a list of articles that have a valid to on next week or even next month? If I receive this email on my day off (or even in the weekend), the article will no longer be visible for end users. 

You can send the authors a list of all of their articles that need to be reviewed within an x period and it will help them in organizing their work instead of being confronted with work they don't have time for? 

The only way you can use 'tomorrow' is by having it run later on the day, so you are in the system time zone.

[ozgurD]

I have now been able to test it and it is actually due to the system time zone. Thank you very much!