0

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.

3
Contributors
8
Replies
9
Views
7 Years
Discussion Span
Last Post by dspnhn
0

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

0

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.

0

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

0

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.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.