Set British Date Format

[Charless Mohan]

How can set date/time data type as british date format dd/mm/yyyy. when I
insert my record it will be change U.S format so I can't retrieve datas based
on dates.

Thanking You
P m R

 

[Wayne-I-M]

Dates are set by the user inserting them.
So, if you have an on-line DB the date will be set by the setting on the
machine being used by the user.
If you are on off-line system then you can set the date format from Regional
Setting in the control panle

Of course you can alter the dates in a query but this is a REAL big problem
as if you have some date US and some UK then you need to have a complex query
to change them all - or some of them.

Best bet would be to ensure that each front and has the correct reginonal
setting in the control panle 1st

If this does not work then post back with more details

 

[Pecoflyer]

Try selecting your dates
Menu Data - text to columns
Check "fixed width"
Next
Next
Under Column data format check " Dates" and select DMY ( also try MDY)

Finis

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answer

 

[Charless Mohan]

Thanking You for your tips. Its also I used but if give our project to others
can we change all setting as british. If you know change in query format
please tell me.

 

[Charless Mohan]

I asked in MS-Access. there in no Data in Menu

 

[Wayne-I-M]

yoiu need to split the field then rearrange the digits into the frormat you
want
use a split then concencate

if you give some examples of the dates you get and what you want many people
here will be able to give you the formula

don't forget to apply a filter to the sub query to take out any dates that
are correct

you can't just re-format as you may have some dates that are correct and
re-formatting will mess these up

 

[Douglas J. Steele]

Take a look at what Allen Browne has at
http://www.allenbrowne.com/ser-36.html or what I had in my September, 2003
"Access Answers" column in Pinnacle Publication's "Smart Access". You can
download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html