Date Conversion

[jameshall]

Hello everyone, my problem is I have a time logger system and I have to generate a weekly report. It consists of a form bound to a report (built by someone else) and two fields for the start and end dates.
My plan was to remove the second field and have a date picker (taken from

http://www.weedmanager.net/access/cals.zip)

that selected the first day of the report and it calculates the rest of the week monday-friday. This works until I input the start date (for example) 08/07/2002, the final day is calculated and when the report is about to be generated the start date now looks like 07/08/2002, but the second date is 12/07/2002!!
Is there some kind of option that can do this by default as this problem is new to me!!

thanks for any help

 

[AlexMidd]

You have a form bound to a report. I do not undertsnad this. Is it actually a report bound to a table?

I suspect this is an international date format problem, and the date is being converted to American format. Can you get at the control for the date field in the report and apply a format, e.g. dd/mm/yyyy? Have fun! )

Alex Middleton