Formula works one day and not the next, Any Help ?

[rico7937]

I have a formula for a change report that I run once a week. The report ran fine Thursday and now today I get this error:

Here is the formula :

If IsNull({CHANGE.PLAN_ST_TIME}) Then
' '
Else (
TimeVar Plan_St_Time := Time(ToNumber(Left({CHANGE.PLAN_ST_TIME},2)),ToNumber(Mid({CHANGE.PLAN_ST_TIME},4,2)),ToNumber(Right({CHANGE.PLAN_ST_TIME},2)));
tzcvtConvToLocalDatetimeByName (ToText(DateTime({CHANGE.PLAN_ST_DATE},Plan_St_Time),"MM/dd/yyyy hh:mm tt"),"Eastern Standard Time"))


I get the following error on the first part of the formula:

The string is non-numeric

TimeVar Plan_St_Time := Time(ToNumber(Left({CHANGE.PLAN_ST_TIME},2))


I have no clue on how to correct this. Any advice would be greatly appreciated !

 

[Madawc]

Expand the first test,

If IsNull({CHANGE.PLAN_ST_TIME}) or {CHANGE.PLAN_ST_TIME} = " "

Your formula looks over-complex. If it still gives trouble, I'd suggest breaking it up into separate formuals and then stringing them together as text.

It helps also to give your Crystal version.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[rico7937]

Thank you so much ! That correction worked ! Sorry about the version which was 10.