Using CSTR

[LeonelSanchezJr]

I have the following formula in my report.

formula = cstr(cdatetime({eaxhawbmawb.destdep}),"dd MMM yyyy HH:mm&quot

It works great except when the time is equal to 12:00 a.m.,
the formula display 00:00

Any ideas?
Thanks,

Leo ;-)

 

[richdb]

If you want to replace it with something else, write an IF..THEN..ELSE condition.

If RIGHT(formula,"00:00&quot then
mid(formula,1,len(formula)-5) & "12 AM"

NOTE:where 5 is equal to the number of characters in "00:00"