I am quite sure that my rule for a my new badge has been set up right. But I would like to double check with you.
I want to launch a badge which is given to all members in the community which will have been registrated from the launch of the community until the 31th of december 2019.
As a result the formula should be like "registration_date <= '2019-12-31T23:59:59'"
Thanks in advanced for your feedback.
Solved! Go to Solution.
Yes your formula is correct,
But, for before next year and current year till 31 DEC 2019 you can also do it simply by giving year.
"registration_date < '2020'" "registration_date < '2020-01'" "registration_date < '2020-01-01'"
2020 = 2020-01-01T00:00:00Z
2020-01 = 2020-01-01T00:00:00Z
2020-01-01 = 2020-01-01T00:00:00Z
2020-01-01T19:20+01:00 = 2020-01-01T18:20:00Z
2020-01-01T19:20:30+01:00 = 2020-01-01T18:20:30Z
2020-01-01T19:20:30.45+01:00 = 2020-01-01T18:20:30Z