Skip to Content
Author's profile photo Arjun Rao

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



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


Thank You.

Best Regards,


Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.