Question about changing the format of Date/time

[Nader]

I have a Column it's type is Date/Time . I want to change the format of this column from MM/dd/yyyy to dd/MM/yyyy. is it possible?

 

[John Big Booty]

It certainly is, check out this article.

 

[Nader]

I read the article, but I don't know how to excute the Sql. I don't where I must to insert the code.

 

[MSAccessRookie]

I have a Column it's type is Date/Time . I want to change the format of this column from MM/dd/yyyy to dd/MM/yyyy. is it possible?

Check out the Format() command, and see if that is what you need. It is easy to understand, and will work both in SQL View and Design View.

 

[Singh400]

Or change the system settings to UK and not US. I've got loads of Date/Time fields and by default the dates are in dd/mm/yyyy format.

 

[MSAccessRookie]

Or change the system settings to UK and not US. I've got loads of Date/Time fields and by default the dates are in dd/mm/yyyy format.

My advice was based on the assumption that they wanted their default to be MM/dd/yyyy and they needed the date to be dd/MM/yyyy for limited purposes only (perhaps international correspondence). I have done similar things in the past. If they want it to be that way all of the time, then by all means, the system settings is the way to go.

 

[John Big Booty]

I read the article, but I don't know how to excute the Sql. I don't where I must to insert the code.

You could put the code behind the on click event of a button.

 

[Nader]

I'm sorry I can't understand. Becaue I didn't work on Ms Access very... I'm using this database in visual studio vb2005.net.So I'm only know how to connecton with.. and some inforamtion.

 

[gemma-the-husky]

data is STORED in the database as a date/time datattype - that shouldnt worry you

when you display the date in a form, or report you can specify the display format as several standard types

eg short date, (17/11/08), medium date (17 Feb 2008) or long date (17th February 2008)

the exact presentation format of these follows your regional settings

--------
if none of these are appropriate you can set your own format, where

ddd mmm etc is the day/month in text, and dd mm yyyy etc is in numbers

--------
so if you want Feb 17 2008

i think you can format mmm dd yyyy