[gop373]

I want to insert date into table name AAA. Table AAA coloum name dat the type of this column date/time m/d/yyyy. Ex. 10/1/2004

dim todaysDate,t,testdate
todaysDate=now()
testdate=FormatDateTime(todaysDate,2)
sql="insert into AAA(dat,price) values('"&testdate&"',"&cp1&")"

But when I check in table AAA the date is like this 1/10/2004 . The form that i want to insert is m/d/yyyy

One more thing. I don't want to use Cstr() because I need to compare date.

sql="select Max(price) as maxprice from Microsoft where dat=date()"

[brayton]

just use date as


strDate = date

you try that yet?

[Naresh Rohra]

Check regional settings Date format. It should be mm/dd/yyy. It will control how date is displayed in MS Access.


Cheers.
Naresh.

[gop373]

Yes, I already try to use strDate = date but that will convert date into string. And the problem is if I convert date into string I can compare date. It doesn't work well if convert date into string.

[hellind2]

If i am not wrong, the date format in your database is the 'regional setting' in your access database.

Once you retreive from you database, it is left to the script to manipulate it.

[Franzioz]

Dim testdate

testdate = month(now()) &"/"& day(now()) &"/"& year(now())