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

/wp-content/uploads/2014/11/valid_date1_595943.jpg

Validation_Transform:


Use this function in this transform – is_valid_date(“DATE“, ‘YYYYMMDD‘) <>0

Untitled.png

Thank You.

Best Regards,

Arjun

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply