Scheduling a report error

[menuch]

I have been getting this problem alot with Schedulers that run my crystal reports. When refreshing the report in Crystal Reports the report runs fine. But when running it through Crystal enterprise or other Crystal Schedulers I get a bad date format error.

Did anyone else ever have this problem??

 

[synapsevampire]

What version of the software, and what type of field is the date, a date or datetime? Is CE on the same machine? If not, could regional settings contribute to this?

-k

 

[menuch]

I am using Crystal 9. The scheduler I am using now is an aftermarket one. I am converting number fields to dates. For example:
Date(totext(YY,0,"&quot/(totext(MM,0,"&quot/(totext(DD,0,"&quot)
and this works fine in Crystal. The reason for the ,0,"" is because if not when run through a veiwer the conversion to text makes the numbers look like 0.00 as apposed to 0.

Hope this helps.
Menuch