"Bad Time Format String" Error Message

[Guest_imported]

I've created a report using date/time fields where I've taken a date field {CloseDate}, a string field {CloseTime} and converted the two fields into one using this formula:

DateTime ({Clsdate}, Ctime({clstime})

So, my date was converted from this:
(3/4/02) (11:00am)
to this:
(3/4/02 11:00:00) = 1 date/time field.

However, when compiling the report and trying to run using CRRUN32 I'm getting an error message:

&quot;Error in file, error in formula <closedate>
DateTime ({Clsdate}, Ctime({clstime})
Bad time format string.&quot;

What's wrong with this logic? When checking for errors I get &quot;No errors found&quot;.

Please help!!

 

[synapsevampire]

Could it be that you have some bad data?

It sounds like the report is compiling and running, you just have some bad data in the time field. Try checking for the existence of null or illegal values in your formula, or better still check the database and correct it.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[rogar]

You could get this error if the string field {CloseTime} does not contain a valid time string in any record. You need to validate this field and provide a default time alternative.