How To Format date in vb6.0 and Access

[andypower]

my self avi i m developing one application in vb 6 and access by using ado library.
when i m inserting record in database the date i want to insert is "09/12/2005" but it stores as "12/09/2005".
i format that date format command in dd/mm/yyyy way and even i use cdate() function but it wont work.
in sql server one can use convert() function is there any such function to use in access or suggest me any other option how to solve above problem

 

[PHV]

Use a non ambiguous date value when you insert date values, like this:
INSERT INTO myTable(myDate) VALUES(#2005-09-12#)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SkipVought]

Hi,

FORMAT and STORE are two DIFFERENT things.

MS Dates are just NUMBERS, like right now in TEXAS its, 38607.47056 which can be FORMATTED in any number of ways for DISPLAY like 9/12/2005 11:17.

Check your Regional settings for default DATE DISPLAY FORMAT.





Skip,
[sub]
[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL![/sub]