Flow Condition query

[hildasteyn]

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?

[Nived_Nambiar]

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! 🙌

[Chriddle]

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

[LinnZawWin · Accepted solution]

@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.

[hildasteyn]

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