alter table to add a formatted DATETIME field

[Guest]

Hi,

i am creating a front-end with visual basic 6 using ADO and ACCESS 2000 as
database.

i need to programmatically add a formatted DATETIME field: "dd/mm/yyyy".

With this code
ALTER TABLE myTable ADD myNewDateField DATETIME

the date format rest not specified...

i have tried
ALTER TABLE myTable ADD myNewDateField DATETIME Format( "dd/mm/yyyy")
and many other ways but nothing...

Please HELP ME!!!!!

Thank You All

 

[Rick Brandt]

Hi,

i am creating a front-end with visual basic 6 using ADO and ACCESS 2000 as
database.

i need to programmatically add a formatted DATETIME field: "dd/mm/yyyy".

With this code
ALTER TABLE myTable ADD myNewDateField DATETIME

the date format rest not specified...

i have tried
ALTER TABLE myTable ADD myNewDateField DATETIME Format( "dd/mm/yyyy")
and many other ways but nothing...

Formatting has nothing to do with how Access stores dates. It only affects
display and is therefore unnecessary at the table level.

 

[Guest]

Formatting has nothing to do with how Access stores dates. It only affects
display and is therefore unnecessary at the table level.

I understand but, formatting also does not affects the way a ADO recordset
retrives the data?