Date Format (1 Viewer)

[armanbkb]

Dear Experts.

I have a query which need date for generate report. On report and table the date format is dd/mm/yyyy.

My PC's short date set (on regional settings) M/d/yy

for why when I input on query date as d/m/yy it's dose not show reports.

Is there any option to solve this problem without change regional setings short date format?
or
Is there any .bat file to set pc's short date format as d/m/yy?

 

[marlan]

Hi,

When filtering by date, the date format is not relevant, Date data type is a floating point numeric value.

You can read some about date formatting: http://www.techonthenet.com/access/functions/date/format.php
tips for working with dates: http://www.techrepublic.com/article/10-tips-for-working-with-dates-in-microsoft-access/
and good general information about Access data types: http://allenbrowne.com/xbase-05.html

ATB!