Hi All
I am using the following code to check a table for a specific date
 & "WHERE ((([Next Due Date])=" & "#" & Date & "#));"
The problem is that the code is formatted for MM/DD/YYYY.
Does anyone know what the code would be for DD/MM/YYYY
Thanks

Brendan Bartley

__________________
Brendan Bartley

I know there have been posts about this several times. You can check the individual dateparts. I would do this, however:

sDate = DatePart("dd", Date) & "/" & DatePart("m", Date) & "/" & DatePart("yyyy", Date)

"WHERE ((([Next Due Date] = '" & sDate & "'"

I think that would work in spite of the data type issues.

HTH

mmcdonal

go to control panel.and change the date format.

That would leave them using the wrong date format for the country, and also require all the users to change the date formats on their computers in order for this function to work.

mmcdonal