Format Date in Access 2007?

[kathnicole]

hi there,

I have a field called DateEnacted (data type :date/time)

could anyone tell me how can i change the format to dd/mm/yyyy , when i enter values in the table, instead of mm/dd/yyyy?

thanks,
Kathy

[MMcCarthy]

hi there,

I have a field called DateEnacted (data type :date/time)

could anyone tell me how can i change the format to dd/mm/yyyy , when i enter values in the table, instead of mm/dd/yyyy?

thanks,
Kathy

Open the table in design view. Go to the format property and replace whatever is there (presumably shortdate) with dd/mm/yyyy

[kathnicole]

Open the table in design view. Go to the format property and replace whatever is there (presumably shortdate) with dd/mm/yyyy

Hi,

I have selected the Short Date but the problem persist with the default settings.

the Short Date in ms access 2007 is mm/dd/yyyy format unlike in ms access 2003. i wanted that to be changed to dd/mm/yyyy

that is were i am getting the problem.

I do not know how to change the format!!!

thanks,
Kathy

[MMcCarthy]

Hi,

I have selected the Short Date but the problem persist with the default settings.

the Short Date in ms access 2007 is mm/dd/yyyy format unlike in ms access 2003. i wanted that to be changed to dd/mm/yyyy

that is were i am getting the problem.

I do not know how to change the format!!!

thanks,
Kathy

Read my post again. I said replace short date with dd/mm/yyyy

[kathnicole]

Read my post again. I said replace short date with dd/mm/yyyy

mccarthy, i've selected the short date for my date field.

in access 2003 , it will be like, short date (dd/mm/yyyy)

but in access 2007, it is like short date (mm/dd/yyyy)

as i am using ms access 2007, i do not know how to change the format like in access 2003?
could you please explain me how to do this??


regards,
kathy

[MMcCarthy]

DON'T select short date.

Just put dd/mm/yyyy in the format property

I don't know how else to explain this.

[Twanne]

I do --> get someone who can read english :D

Sry to be so abrupt but Mc is right. Just replace the property value to whatever you want. (dd/mm/yyyy)

If you are having trouble because it isn't inserted right, use the function DateSerial(year,month,day). It places a date in any sort of date field in the correct order.

Greetz
Twanne

Über, über, upper sounds better.

[kathnicole]

I do --> get someone who can read english :D

Sry to be so abrupt but Mc is right. Just replace the property value to whatever you want. (dd/mm/yyyy)

If you are having trouble because it isn't inserted right, use the function DateSerial(year,month,day). It places a date in any sort of date field in the correct order.

Greetz
Twanne

Über, über, upper sounds better.

guys,

i do understand wat u r trying 2 say...

the format only works for a new table. say if i have a table with no records, and if i format the date field as dd/mm/yyy, it works good.


but i have 100 records in the table (import from another database) and if i format the date, it doesnt works. it still remains as mm/dd/yyyy.

i feel sorry if this reply frustrates anyone.

regards,
Kathy

[MMcCarthy]

guys,

i do understand wat u r trying 2 say...

the format only works for a new table. say if i have a table with no records, and if i format the date field as dd/mm/yyy, it works good.


but i have 100 records in the table (import from another database) and if i format the date, it doesnt works. it still remains as mm/dd/yyyy.

i feel sorry if this reply frustrates anyone.

regards,
Kathy

OK that is different. You want to change the existing records. To do that create an update query as follows:

UPDATE TableName SET DateField = Format([DateField], "dd/mm/yyyy")

See if that works for you.

Mary

[kathnicole]

OK that is different. You want to change the existing records. To do that create an update query as follows:

UPDATE TableName SET DateField = Format([DateField], "dd/mm/yyyy")

See if that works for you.

Mary

thanks MC...

alas, i got it right..

thanks for being so hepful...

chuz,

Kathy