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
Get Started with Redwood for Oracle Cloud HCM   Begin Now

Date Conversion in auto complete

Accepted answer
51
Views
4
Comments
edited Sep 11, 2023 11:48AM in HCM Experience Design Studio: Autocomplete Rules 4 comments

Summary: We have a requirement to compare Date of Birth with identity number first 6 digit. In order to achieve the same we are trying to build this rule via auto complete rules. But struggling to find the correct date conversion option.

Either We have to convert the DOB to YYMMDD format or YYMMDD to Date format so as to compare both these date. Can anyone please help. Currently its failing even for correct entries.

Attaching the Grovy Script for the same:-

if( ( ((adf.source?.LegislationCode=="ZA")) && 

((adf.source?.NationalIdentifierType=="ORA_HRX_ID_NUMBER")) && 

(adf.source?.NationalIdentifierNumber != null) ) )

{

def var_stringVar_DOB1 = adf.util.subString(adf.source?.NationalIdentifierNumber,0,2 ) ;

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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