Unanswered

Flow Condition query

(0) Share

Report

Posted on by Hilda Steyn

271

I am playing with a simple flow to evaluate a client's birth date from my clients table. If the month and day = today(), I want a birthday reminder.

I have a test client that I use. I changed the client's birth date to 30 August simply to test the flow.

Nothing happened.

I checked the flow results - see screen shot 2 - I changed the birth date to 30 August. Where does the 29 August come from?

Categories:

General topics

screen shot 2.png

I have the same question (0)

All responses (4)

Answers (1)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @hildasteyn

Could u show the flow design ?

Also where you are storing the data , in dataverse table ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
Chriddle 8,422 Super User 2025 Season 2 on at

Like (0)

Report
equals(utcNow('MM-dd'), formatDateTime('2023-08-30', 'MM-dd'))

Was this reply helpful? Yes No
Verified answer

Linn Zaw Win 2,996 on at

Like (0)

Report

@hildasteyn

29 August comes from the actual data stored in the database. When you create a "Date only" column with default "User local" time zone adjustment setting, the system stores the value as UTC date in the database. Since the time zone setting of the user who saved the record is GMT+3, the 30th Aug is stored as "1969-08-29T21:00:00Z" (UTC time) in the database. Read more details in this blog post.

How are you getting the client data where the Date of Birth month and day = today()?

If you are querying all the data and get the Month and Day part, you need to convert the time zone of the value before getting the Month and Day part. You can either do it with the action or expression.

But for this scenario like the Date of Birth, I would recommend deleting and re-creating the column (if possible) as Time Zone Independent so that you don't have to worry about such an issue.

Was this reply helpful? Yes No
Hilda Steyn 271 on at

Like (1)

Report

Thank you. I appreciate the time you took to give such a comprehensive answer.

Was this reply helpful? Yes No