Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BAD Time Format String Error

I am getting a bad time format string error. I run the check and it gives me no errors found. When I refresh the report is when I recieve the bad time format string error. I have a feeling it is a null value I just do not know how to write the if statement. Please help. Here is the actual code:

Minute(CTime ("00:" + {EVAL_COMMENTS_Duration.COMMENTS}))* 60 + Second (CTime ("00:" + ({EVAL_COMMENTS_Duration.COMMENTS})))

Former Member
Former Member replied

To cater for nulls try

If isnull|( {EVAL_COMMENTS_Duration.COMMENTS}) or {EVAL_COMMENTS_Duration.COMMENTS} = '' then 0 else

Minute(CTime ("00:" + {EVAL_COMMENTS_Duration.COMMENTS}))* 60 + Second (CTime ("00:" + ({EVAL_COMMENTS_Duration.COMMENTS})))

Ian

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question