date formats in report

[ndendrinos]

Hello to all,
I have a report that prompts me to enter the "start date" to "end date"
I have formated the dates for the report to : dd mm yyyy
Odly enough that translates to 12/31/2003 and that's OK .

My problem is with the prompter at the start date to get 12/31/2004 I have to type the start date as 31/12/2003 .... But hey...I'm easy ... so that's OK too.
To get the end date I have to type 12/31/2004 ... but then again it's Christmas so that's OK also...
BUT... while the dates of the report are OK the dates in the top of my report showing the range chosen is all wrong...
Here is what it looks like:

Purchases by Company From: 12/31/2003 to 31/12/2004

Apple.....12/31/2004....$5.00

I keep changing the format of the date field in the date range to dd mm yyyy to no avail.... cna anyone help ?

Thank you

 

[Andrew Fergus]

Hi

You might want to start by checking the global settings on the PC (on the Control Panel) as well as checking the formats in the underlying tables, queries and in the report.

In your query you can also change the way the prompt appears, so instead of having : =[Enter start date] you can have something like : =[Enter start date (format dd/mm/yyyy)] so that the user is prompted for the correct format.

Lastly, there is a 'Format' function that you might be able to use in your query if none of the above suggestions work.

HTH, Andrew

 

[ndendrinos]

Thank you Andrew... will work on it during the Holidays.
Merry Christmas to you
Regards,
Nick