Bad date format string

[jcl5]

Hi

Using oracle 8 and Crystal 10

I have a report which stores only month and year (as numbers) and I need to perform a calculation based on the last day of that month field.

I have converted it using the following formulas:-
@GVAToDate
cdate(({GVA.YEMONTH}&'/'&{GVA.YEAR}))

@LastDay
dateserial(year({@GVAToDate}), month({@GVAToDate})+1,01)-1

This seems to work fine when running the report through the designer.
When I publish it through Enterprise I get error:-

Errors Occured When Refreshing Report.
-2147191654 - Bad date format string. - Logon To Server is OK - Reading Records

Can anyone help?

Thanks

jcl5

 

[lbass]

Try:

dateserial({GVA.Year},{GVA.yemonth}+1,01)-1

-LB

 

[jcl5]

Sorry lbass, doesn't make any difference. I think the formula is ok, it produces the correct results, it just returns the error through enterprise.

 

[lbass]

Then I would try the Crystal Enterprise forum.

-LB

 

[synapsevampire]

Dateserial works on our CE 10 just fine, as does Oracle 8.

Anyway, try the following instead:

if isdate({@GVAToDate}) then
totext(Dateadd("m",1,{@GVAToDate})-1)
else
"Bad date format"

This eliminates the dateserial (which I doubt is the issue) and it checks for bad data format.

If that works, you might also try:

if isdate({@GVAToDate}) then
totext(dateserial(year({@GVAToDate}), month({@GVAToDate})+1,01)-1)
else
"Bad date format"

The issue appeared to be a null or bad value in a field to me, your formulas seemed fine.

-k