Skip to Content

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



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


Thank You.

Best Regards,


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