Answered

Flow Condition query

(0) Share

Report

Posted on by Hilda Steyn

289

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

I have the same question (0)

All responses (4)

Answers (1)

Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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,638 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

@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 289 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No