[thelist] Access Date Trouble
rudy
r937 at interlog.com
Tue Dec 18 07:45:19 CST 2001
>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
More information about the thelist
mailing list