Field need to be required for new record created from mention date

I have created a new field in one of the module and that field needs to be required for created after any set date (i.e. 2020-10-20), that should not be required for old records. I am using the below formula to achieve this but somehow the formula is not working. Please suggest any solution.

Fullscreen

1
or(not(greaterThan(strlen(toString($date_created)),0)),isAfter($date_created,date("2020-10-20")))
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

or(not(greaterThan(strlen(toString($date_created)),0)),isAfter($date_created,date("2020-10-20")))

0 Gurpreet Singh over 4 years ago

Neeraja P
0 André Lopes over 4 years ago in reply to Gurpreet Singh

Perhaps this formula works

or(equal($id,"")isAfter($date_created,date("2020-10-20")))

André Lopes
Lampada Global

Skype: andre.lampada
0 Gurpreet Singh over 4 years ago in reply to André Lopes

Thanks for your response, but below code is not working:

isAfter($date_created,date("2020-10-20"))
+1 Neeraja P over 4 years ago in reply to Gurpreet Singh
The field that you need to use for "Created Date" is $date_entered and not date_created.

So for new records (create view), you can use equal($id, ""), as Andre suggested.

For existing records (record view), you can use isAfter($date_entered,date("2020-10-20"))

So, the final criteria that you need to use is a slightly modified version of Andre's solution:

or(equal($id,""), isAfter($date_entered,date("2020-10-20")))
0 Gurpreet Singh over 4 years ago in reply to Neeraja P

Neeraja P Thanks for your help!