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

Avatar

Avatar

eveline8

Avatar

eveline8

eveline8

10-01-2018

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?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

alicep47308254

Avatar

alicep47308254

alicep47308254

10-01-2018

Hi Eveline,

I tried with this formula and everything works.

I also tried today with the date 31/12.

Have a nice day

Alice

2018-01-10 12_15_50-Query.png

Answers (1)

Answers (1)

Avatar

Avatar

eveline8

Avatar

eveline8

eveline8

10-01-2018

Hi Alice,

thanks for your answer!

I tried your formula and it works.

Bye,

Eveline