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

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

Avatar

Avatar
Validate 10
Level 3
eveline8
Level 3

Likes

24 likes

Total Posts

70 posts

Correct Reply

5 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
eveline8
Level 3

Likes

24 likes

Total Posts

70 posts

Correct Reply

5 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
eveline8
Level 3

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
Validate 10
Level 3
alicep47308254
Level 3

Likes

18 likes

Total Posts

43 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
alicep47308254
Level 3

Likes

18 likes

Total Posts

43 posts

Correct Reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
alicep47308254
Level 3

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
Validate 10
Level 3
eveline8
Level 3

Likes

24 likes

Total Posts

70 posts

Correct Reply

5 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
eveline8
Level 3

Likes

24 likes

Total Posts

70 posts

Correct Reply

5 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
eveline8
Level 3

10-01-2018

Hi Alice,

thanks for your answer!

I tried your formula and it works.

Bye,

Eveline