cancel
Showing results for 
Search instead for 
Did you mean: 

How do I use the is_valid_time function in BODS?

former_member275081
Discoverer
0 Kudos

I am using is_valid_time function to validate a string. The function detects the string as time only when the string is less than 051300. For example when the input is '051500' the function below returns 0.

The function: is_valid_time('051500','HHMMSS')

Accepted Solutions (1)

Accepted Solutions (1)

aasavaribhave
Advisor
Advisor

you need to use is_valid_time('051500','HHMISS')

MM - month - goes from 01 - 12

MI - minute goes from 00 - 59

Check for function def in http://help.sap.com/businessobject/product_guides/sbods42/en/ds_42_reference_en.pdf

Answers (1)

Answers (1)

former_member186894
Participant
0 Kudos

is_valid_time('051500','HHMMSS') is false so it would return 0. where is_valid_time('051100','HHMMSS') is true so it would return 1.

Thanks,

Imran