By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,492 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Format Date in Access 2007?

P: 33
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
Sep 19 '07 #1
Share this Question
Share on Google+
9 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
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
Sep 19 '07 #2

P: 33
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
Sep 20 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Sep 20 '07 #4

P: 33
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
Sep 21 '07 #5

MMcCarthy
Expert Mod 10K+
P: 14,534
DON'T select short date.

Just put dd/mm/yyyy in the format property

I don't know how else to explain this.
Sep 21 '07 #6

P: 65
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.
Sep 21 '07 #7

P: 33
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
Sep 25 '07 #8

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Sep 25 '07 #9

P: 33
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
Sep 26 '07 #10

Post your reply

Sign in to post your reply or Sign up for a free account.