datetime field to date field with parameter

[needmoremoney]

I'm trying to convert a datetime field into just a date field.

I have {SBatch.beginDate} as a datetime field.
I want to convert this into a Date field (MM/DD/YYYY) field.

Then after this, I want to run run a parameter that asks for the beginDate.

Not sure how to set this up. Any help.. thanks

 

[needmoremoney]

Just to clarify things more. When I run a parameter to collect data from 04/07/2005, the crystal report only pulls data from 04/07/2005 at 1:00:00pm. I want to eliminate the time. All the data from this date should appear in the report.

 

[dgillz]

Date({YourDateTimeField}) should do the trick.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[needmoremoney]

Thanks,

I'll try that.. my problem is when I run my parameter, it searches for the datetime and not the date. It won't display all the fields but only one field (datetime). ie. 3/1/05 1:00:00am.


thanks though, I'll try that..

 

[kskid]

Sounds like your parameter is in datetime format. Change it to date

-LW