I made a datareport. I select a date from dtpicker and the datareport show that date data.
here I want the selected date (by dtpicker) will show in the report.
like:
05-06-09
or
from 01-06-09 to 05-06-09
any body help me please.

It looks like you are trying to pass a date in the format of day month year. For this to work your database needs to be in the same format and most databases use the format of month day year.


Good Luck

both are same format. I know like %d . it show the current date in report. but I want it show selected date what selected from dtpicker.

Well, you can set the format from the DTP or you can use the functions I mentioned above and when you query you may need to use the # symbols around the date if access.

Anybody else want to pipe in???


Good Luck

where exactly are you using this

"from 01-06-09 to 05-06-09"

is it in the title. Then simply use a string variable like
datareport1.title="From " & dt1 & " to " & dt2

This question has already been answered. Start a new discussion instead.