You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Fast formula to check if DOB filed is blank then return ineligible

Received Response
12
Views
1
Comments

Summary:

I want a condition to determine if dob is blank then it must not be eligible .When I tried to pass blank it is not working?Can someone help?



Inputs are BEN_IV_EFFECTIVE_DATE(TEXT)

default for BEN_IV_EFFECTIVE_DATE is '1951/01/01 00:00:00'

/*DEFAULT_DATA_VALUE FOR PER_EXT_CONT_**** IS 'xx'*/

DEFAULT_DATA_VALUE FOR PER_PER_CONTACT_**** IS 'xx'

DEFAULT for PER_PER_DATE_OF_BIRTH is '1951/01/01 12:00:00' (date)

DEFAULT_DATA_VALUE FOR PER_PER_CONT_REL_CONTACT_TYPE IS 'xx'

DEFAULT FOR PER_PER_**** IS 'UNKNOWN'

DEFAULT_DATA_VALUE FOR PER_PER_CONT_REL_CONTACT_PERSON_ID IS 0 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!