alter table to add a formatted DATETIME field

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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...
Click to expand...

Formatting has nothing to do with how Access stores dates. It only affects
display and is therefore unnecessary at the table level.
 
Rick Brandt said:
Formatting has nothing to do with how Access stores dates. It only affects
display and is therefore unnecessary at the table level.
Click to expand...

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