Expand my Community achievements bar.

SOLVED

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

Avatar

Level 4

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?

1 Accepted Solution

Avatar

Correct answer by
Level 4

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

View solution in original post

2 Replies

Avatar

Correct answer by
Level 4

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

Avatar

Level 4

Hi Alice,

thanks for your answer!

I tried your formula and it works.

Bye,

Eveline