Bad Date Format String?

[ShowersDK]

Can someone tell me whats wrong with this formula? It works in Crystal but
when I open the report through IE I get the Bad date format string error.

dateadd("m", 4, DateValue({?PeriodView} + "/01/" + Cstr(Year(CurrentDate))))

(where periodview is to char string of two numbers ranging from 01 to 12)

Thanks,
Darren

 

[kenhamady]

Does it run from CR installed on the server? It may be that the DateValue() function is from a DLL that isn't available. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[ShowersDK]

I've tried DateValue, CDate, and DTStoDate and they all fail. Any suggestions?

Thanks,
Darren

 

[dgillz]

I think Ken was asking if this report works when you do not access the report through a browser. Did you test that first? Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[ShowersDK]

The report works fine in Crystal Reports. I saved and refreshed the report a number of times.

Thanks,
Darren

 

[kenhamady]

Is CR installed on your server?
I am not sure which part of the formula it is rejecting.
What if you use this formula as a test?

dateadd("m", 4, Date (2002,5,28)) Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[ShowersDK]

That seems to have done the trick. Thanks!!!!

 

[kenhamady]

ShowersDK - I am curious as to what did the trick. My last formula was just a test, with a hard coded date, to help find the problem. What formula did you end up using? Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com