I am using MSDE for the first time and am having problems with dates. I
have had this problem with dates on all the DB's I have used. I can just
never work out the format...
'Insert into Table (aDate) values (''#'+FormatDateTime('yyyy-mm-dd
hh:nn:ss', Now)+'#'')' ;
What format string should I use for this to work?
Using DBGo TADOQuery...
Cheers,
David O'Brien.