How to use is_validate_date function?

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