Is_valid_date is commonly commonly used function in SAP BODS.
It will validate the date field with the given format as shown below:
is_valid_date("DATE", 'YYYYMMDD') <>0
DATE > Date Field object
Create a data flow as mention:
Source table or file > Query_Transform > Validation_Transform > Target Table
Validation_Transform:
Use this function in this transform - is_valid_date("DATE", 'YYYYMMDD') <>0
Thank You.
Best Regards,
Arjun
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.