You need to sign in to do that
Don't have an account?
certi_vimal
Anniversary Date field in 2 formats
I have a requirement where user can be allowed to fill its Wedding Anniversary Date in 2 formats :-
- MM/DD/YYYY - MM/DD I know with standard Date field this is not possible, so I may need to use text field type. However, I am struggling to write Validation Rule for the same. This is my Val Rule in construction :- (NOT(ISNUMBER(RIGHT(Wedding_Anniversary__c, 2)) && ISNUMBER(LEFT(Wedding_Anniversary__c, 2)) && VALUE(LEFT(Wedding_Anniversary__c, 2) ) <= 12 && VALUE(RIGHT(Wedding_Anniversary__c, 2)) <= 31 && VALUE(LEFT(Wedding_Anniversary__c, 2) ) <> 0 && VALUE(RIGHT(Wedding_Anniversary__c, 2)) <> 0 && CONTAINS(MID( Wedding_Anniversary__c, 1, 5),'/'))) && NOT (ISBLANK (Wedding_Anniversary__c)) Can anyone please assist me? Thanks, Vimal |
I would seriously push back on this "requirement" this is going to lead to all kinda of problems with data quaility. Have them pick 1 format and work with that.