how is the server setup is it uk format or us format that make a big differance
or you can set the page to the right format
for a safe beat I always write my querys so that the date is in USA
[CODE]
function USAD(date)
USAD = month(date) &"\" & day(date) & "\" & Year(date)
End Function
[\CODE]
so the code would look some like
SQL = "SELECT bla.* FROM BLA WHERE MYDATE = #" & USAD(ThisDATE) & "#"
when displaying the data back to the Screen HTML
at the top of the page put this
<%session.lcid=2057%>
__________________
hope this help
See clear as mud
StePhan McKillen
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment:
Access based on my own environment: DAO3.6/A97/A2000/A2003
VB based on my own environment: vb6 sp5
ASP based on my own environment: 5.6
VB-NET based on my own environment started 2007
SQL-2005 based on my own environment started 2008
MYLE