Badge rule: Registration

[CKummer]

Hi everybody, 

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'"

Right?

Thanks in advanced for your feedback. 

Christoph

[Parshant · Accepted solution]

@CKummer,

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