Hi! I need some help please...I need to insert a date to a table with

format "mm/dd/yyyy".  But the vb program inserts the record as

"dd/mm/yyyy" to the table(ms access).  The program is working correctly

in my pc. But when i try to install it to another pc that's where the

program inserts "dd/mm/yyyy".   I've checked the regional setting, my pc

has a short date style, MM/dd/yyyy and long date style, dddd, MMMM dd,

yyyy and the other pc has the same format. I've tried using mm/dd/yyyy as a 

format to the access table and input mask 00/00/0000 but it still inserts 

the same incorrect date. 

Thanks in advance. 



Ched Venzon

Ched,

  The obvious questions arises... why do you wish to insert data into the 

table in a format, when the data in the table is saved in a standard 

format anyhow (e.g. number of days since 12/30/1899 and then time expired -

 to 7 decimal places - since midnight)?

  You need simply worry about how the data is displayed on your Form / 

Report, at which point you may format the display control as you need to.



Tony





> Hi! I need some help please...I need to insert a date to a table with

> format "mm/dd/yyyy".  But the vb program inserts the record as

> "dd/mm/yyyy" to the table(ms access).  The program is working correctly

> in my pc. But when i try to install it to another pc that's where the

> program inserts "dd/mm/yyyy".   I've checked the regional setting, my pc

> has a short date style, MM/dd/yyyy and long date style, dddd, MMMM dd,

> yyyy and the other pc has the same format. I've tried using mm/dd/yyyy 

as a 

> format to the access table and input mask 00/00/0000 but it still 

inserts 

> the same incorrect date. 

> Thanks in advance. 

> 

> Ched Venzon

> 

> 

> 

It's not saving in a standard format or should i say correct date, because when i searched for 

the date that i previously inserted(ex. 07/09/2001) in the table, no record is found.  When i 

tried to view the table using ms access, the date is 09/07/2001 so most probably the value 

inserted is really sept 07 and not the correct date, july 9.  



> Ched,

>   The obvious questions arises... why do you wish to insert data into the 

> table in a format, when the data in the table is saved in a standard 

> format anyhow (e.g. number of days since 12/30/1899 and then time expired 

-

>  to 7 decimal places - since midnight)?

>   You need simply worry about how the data is displayed on your Form / 

> Report, at which point you may format the display control as you need to.

> 

> Tony

> 

> 

> > Hi! I need some help please...I need to insert a date to a table with

> > format "mm/dd/yyyy".  But the vb program inserts the record as

> > "dd/mm/yyyy" to the table(ms access).  The program is working correctly

> > in my pc. But when i try to install it to another pc that's where the

> > program inserts "dd/mm/yyyy".   I've checked the regional setting, my 

pc

> > has a short date style, MM/dd/yyyy and long date style, dddd, MMMM dd,

> > yyyy and the other pc has the same format. I've tried using mm/dd/yyyy 

> as a 

> > format to the access table and input mask 00/00/0000 but it still 

> inserts 

> > the same incorrect date. 

> > Thanks in advance. 

> > 

> > Ched Venzon

> > 

> > 

> >