cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
%3CLINGO-SUB%20id%3D%22lingo-sub-541104%22%20slang%3D%22en-US%22%3EBadge%20rule%3A%20Registration%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-541104%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everybody%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20quite%20sure%20that%20my%20rule%20for%20a%20my%20new%20badge%20has%20been%20set%20up%20right.%20But%20I%20would%20like%20to%20double%20check%20with%20you.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20launch%20a%20badge%20which%20is%20given%20to%20all%20members%20in%20the%20community%20which%20will%20have%20been%20registrated%20from%20the%20launch%20of%20the%20community%20until%20the%2031th%20of%20december%202019.%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20a%20result%20the%20formula%20should%20be%20like%20%22%3CSPAN%3Eregistration_date%20%26lt%3B%3D%20'2019-12-31T23%3A59%3A59'%22%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ERight%3F%3C%2FP%3E%3CP%3EThanks%20in%20advanced%20for%20your%20feedback.%26nbsp%3B%3C%2FP%3E%3CP%3EChristoph%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-541324%22%20slang%3D%22en-US%22%3ERe%3A%20Badge%20rule%3A%20Registration%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-541324%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.khoros.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F52795%22%20target%3D%22_blank%22%3E%40CKummer%3C%2FA%3E%2C%3C%2FP%3E%3CP%3EYes%20your%20formula%20is%20correct%2C%3C%2FP%3E%3CP%3EBut%2C%20for%20before%20next%20year%20and%20current%20year%20till%2031%20DEC%202019%20you%20can%20also%20do%20it%20simply%20by%20giving%20year.%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%22registration_date%20%26lt%3B%20'2020'%22%0A%0A%22registration_date%20%26lt%3B%20'2020-01'%22%0A%0A%22registration_date%20%26lt%3B%20'2020-01-01'%22%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E2020%20%3D%202020-01-01T00%3A00%3A00Z%3C%2FP%3E%3CP%3E2020-01%20%3D%202020-01-01T00%3A00%3A00Z%3C%2FP%3E%3CP%3E2020-01-01%20%3D%202020-01-01T00%3A00%3A00Z%3C%2FP%3E%3CP%3E2020-01-01T19%3A20%2B01%3A00%20%3D%202020-01-01T18%3A20%3A00Z%3C%2FP%3E%3CP%3E2020-01-01T19%3A20%3A30%2B01%3A00%20%3D%202020-01-01T18%3A20%3A30Z%3C%2FP%3E%3CP%3E2020-01-01T19%3A20%3A30.45%2B01%3A00%20%3D%202020-01-01T18%3A20%3A30Z%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Advisor

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

Right?

Thanks in advanced for your feedback. 

Christoph

1 Reply 1
Highlighted
Honored Contributor

@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

 

 

.......
Do you know we work with Kudos and Accepted Solution.