Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Putting date from a DTpicker to crystal report

Status
Not open for further replies.

eli13

Programmer
Jan 20, 2010
18
PH
I have a problem putting date from a DTpicker of my form to the report, i am trying to create a report of date range, and showing to the report the range he/she sorted.

Example:

i want to show report from 1/1/2010 - 2/1/2010
the report should be like this
--------------------------------------------------------
From: 1/1/2010 TO: 2/1/2010

COde Title Date
1 Sample 1/28/2010
--------------------------------------------------------
the date 1/1/2010 and 2/1/2010 are from a DTpicker
and the data are from the database.

Help please....
 
Create a formula:

"From: "+totext(minimum({?daterange}),"M/d/yyyy")+ " TO "+
totext(maximum({?daterange}),"M/d/yyyy")

-LB
 
the date is from the DTPicker from a form1. how can i put the date in the DTpicker to the crystal report i'm working on,
 
the dates in my example are from 2 DTpicker(VB fields), from a search form, it is a range to set the query. and i want that range to be shown in the report.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top