how can i get information about a customer between two given dates e.g 1-1-2005 to 31-1-2005 in seagate crystal report 8.5

[Edited by hitech_huzefa on 20-07-2005 at 03:13 AM GMT]

Use RecordSelectionFormula property of the CRAXDRT.Report object.

____________________________
If you find the answer helpful, please mark this topic as solved.

Hi goran
can u write the exact formula for me.

should be something like this

rpt.ReportSelectionFormula="{TableName.DateField}>#1/1/05# And {TableName.DateField}<#31/1/05#"

____________________________
If you find the answer helpful, please mark this topic as solved.

Just adding to GOran's comments:

sel = "{<Tblname>.<FieldNAme>}in date (" & Text1.Text & ") to date (" & Text2.Text & ")" CReportDailyApp.SelectionFormula = sel CReportDailyApp.Action = 1

____________________________
Im JAMES