Skip to Content
0
Former Member
Nov 11, 2008 at 12:33 PM

Date Time Field Selection Issue

10 Views

Hi, I Am using Crystal Reports XI and I having a problem with a date-time field. I ave a formula field INVDATE defined as (tonumber(totext(year({OINV.DocDate}),'##')totext(month({OINV.DocDate}),'#')totext(day({OINV.DocDate}),'#')), In the Select Expert I have the following comparison ({@INVDATE}in {?Begin Date} to {?End Date}) the begindate/enddate are defined numeric parameters. My Field from the table is define as date time field. My reports is only picking up records from 20081110, but I am passing parameter values of 20081101 to 20081130. Ny idea's on how to correct this.

Thanks