Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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