BAD Time Format String Error

[Former Member]

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 · Accepted solution]

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

[Former Member]

you can check for nulls:

IF isnull({EVAL_COMMENTS_Duration.COMMENTS}) or TRIM({EVAL_COMMENTS_Duration.COMMENTS})="" then

TIme(0,0,0)

else

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