AC v.6 Workflow birthday 1st day of the month

[eveline8]

Hi,

I create a workflow for users with birthday date equal yesterday but i have a problem.

When we are on 1st day of month the query takes the customers with day of birth 1 day ago and month of birth current month but it's wrong, it also wrong put month of birth 1 month ago.

Anyone has already set a query to takes this customers?

[alicep47308254 · Accepted solution]

Hi Eveline,

I tried with this formula and everything works.

I also tried today with the date 31/12.

Have a nice day

Alice

[eveline8]

Hi Alice,

thanks for your answer!

I tried your formula and it works.

Bye,

Eveline