passing date parameters in a url

[katenorster]

Hi everyone,
I'm hoping that this is not a tricky question, it can't be, everyone must want to be able to pass a date to a Crystal report in a url, (well at least at some stage).

I'm using CR 8.5 with Cold Fusion (although I don't think that the CF is the problem). I have the following url,
<a href=&quot;#application.crystal_server#?id=1766&init=ACTX&apsuser=guest&apsauthtype=secEnterprise&PROMPTEX-Date_from@='#month_start#'&PROMPTEX-date_to@='#month_end#'&PROMPTEX-region_id@=#attributes.region_id#&quot; target=&quot;new&quot;>supplier_late_arrivals</a> where month_start is in the format yyyy,mm,dd.
When I click on my link CR gives me a popup calendar to choose the date values, i.e. ignores the url parameter.

What am I doing wrong?! I'm going greyer by the minute.

Thanks in advance for all you help

Kate

 

[kenhamady]

If you are getting prompted that means that CR isn't getting the prompt correctly. I think your syntax should be either:
#12/31/2001# or Date(2001,12,31)

and yours is passing as: #2001,12,31# 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