format Access date field to match Access calendar input

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report with several date parameter queries. I created a form with a
calendar for beginning date and calendar for end date. Here is my problem:

Calendar returns a date as 12/1/2005 not as 12/01/2005. I tried formatting
the data with an expression field using mm/d/yyyy. This seems to work except
for running the report from the 1st of the month. For example a date range
11/1/2005 thru 11/9/2005 picks up the 10th thru the 19th also (I guess
because it is looking at the single "d" in the date format. How do I format
so that the "01" is read as "1" without pulling in dates from the "10th" thru
the "19th".
Thanks, LindaOSU
 
What exactly do you mean by you tried formatting the data with mm/d/yy.
Where? How?

How is the query implemented to use the data from the Calendar.(I assume
this is a calendar control.)
 
Hi Steve. I think I may have started on the answer. I put a text box on the
form, forced the calendar entires to there, and then formatted the text box.
Then I pointed the queries to get the dates from the text boxes. Does this
sound right to you? It seems to be working. (I have no idea where I got the
mm/d/yyyy idea from).
 
Are you expecting that the way the data is displayed on the form, will be
the same way it will be on the report? (Assuming that report means an Access
Report Object.)
 
I was having trouble because the data had the date in one format and the
calendar object put it in a differnt format. So I had to calender populate
the text box and then formatted the text box to match the data. This would
be easier to do if Microsoft allowed the calender dates to be formatted
directly. It seems to be working now. Thanks for your imput!
 
Back
Top