[thelist] Access Date Trouble

[rudy]

>idate = FormatDateTime(objRS("idate"), 2)

sorry, no speak asp

why not get msaccess to hand you whichever format you want as a char
string?  that way you can isolate the problem

try this in your query --

   select   Format(idate, 'd mmmm yyyy') as idate
     from...

so that idate comes back from the database as a string

that particular user-defined format breaks down like this --

   d  -- Display the day as a number without a leading zero (1 – 31).
   mmmm -- Display the month as a full month name (January – December).
   yyyy -- Display the year as a 4-digit number (100 – 9999).
            (from the msaccess help doc)

this will, without a doubt, tell if if msaccess or your system clock is
fux0red


rudy