Showing results for 
Show  only  | Search instead for 
Did you mean: 

Badge rule: Registration

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


Thanks in advanced for your feedback. 


1 Reply 1


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



Expecting your Kudos and Accepted Solution to my replies.

Welcome to the Technology board!

Curious about our platform? Looking to connect on social technology? You've come to the right place!

Are you a Khoros customer? For direct assistance from our Support team, please visit the Support Forum.