Date field search

[pmaxon]

I am using VB6 CR 8.5 and OCX. I have a database date/time field on a report in the format of mm/dd/yyyy. I am needing to pass a parameter from a form to search by yyyy. Would the conversion from mm/dd/yyyy to yyyy be done on the crystal side or the vb side and how might you do this?

TIA

 

[MColeman]

BlurredVision posted a good FAQ about dates in the Crystal Formulas forum.

faq767-1973

 

[pmaxon]

Unfortunately, the link

http://www.crystalcommunity.com/formulas.php

is no longer a valid link.

 

[synapsevampire]

You can do it on either side.

You can create a recordset and pass it to the report, or embed the parameter and pass it to the report and let Crystal handle it.

Here's the RDC sample applications:

http://support.businessobjects.com/communityCS/TechnicalPapers/apps_rdc.pdf.asp

Another factor would be what type of database object you're using (Table/View/SP/Function).

If the report might have functionality outside of your report, such as compiled on desktops or through other tools, I would suggest placing the parms in the report and then setting them from within CR so that the report is self contained.

-k

 

[MColeman]

Sorry, pmaxon!

Try this one...

http://support.businessobjects.com/communityCS/TechnicalPapers/scr567_datetimefunctions.pdf.asp

 

[pmaxon]

I using access 2000 database and the ocx not the rdc synapsevampire

 

[synapsevampire]

Sorry, I missed that you were using the OCX, and I thought that you were using VB, not Access (Access uses VBA).

Consider switching to the RDC, the OCX is old technology.

-k

 

[pmaxon]

I'm using VB6 and an access database. This is an existing application which uses the OCX. There are numerous reports already setup with the OCX and I was a little nervous about switching everything over since the bulk of the application is working.