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.
abu taher
34
Practically a Posting Shark
Recommended Answers
Jump to PostFormat function, FormatDate Function...
Good Luck
Jump to PostIt 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
All 8 Replies
abu taher
34
Practically a Posting Shark
any body help me please
vb5prgrmr
143
Posting Virtuoso
Format function, FormatDate Function...
Good Luck
abu taher
34
Practically a Posting Shark
I know some function but it show the current date.
vb5prgrmr
143
Posting Virtuoso
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
abu taher
34
Practically a Posting Shark
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.
vb5prgrmr
143
Posting Virtuoso
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
abu taher
34
Practically a Posting Shark
whole thing I don't understand. please explain.
dspnhn
10
Junior Poster in Training
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
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.