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

Learn more

View all

Sign in to view all badges

SOLVED

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

eveline8
Level 4
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
alicep47308254
Correct answer by
Level 4
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
alicep47308254
Correct answer by
Level 4
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

eveline8
Level 4
Level 4

Hi Alice,

thanks for your answer!

I tried your formula and it works.

Bye,

Eveline