Date delimiter in TURKEY

[John Smith]

Hi all.

Is it possible that I have to change my SQL query in Turkey?
Should I use "." instead of "/" ?
(AFAIK in Turkey dates are like DD.MM.YYYY)

TIA
Guy

 

[Guest]

I don't think so. AFAIK, literal date values must be in the US format
"mm/dd/yyyy" or an internationally unambiguous format like "yyyy-mm-dd" and
enclose in hashes (#). My Regional Setting for date is dd/mm/yyyy but in SQL
String, I still use #mm/dd/yyyy#.

OTOH, you already knew the possibilities so a quick test will show whether
you have to change or not.

 

[Allen Browne]

See:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html

The article explains that the interface uses your regional format, whereas
literal dates in SQL statements and VBA code are interpreted as US format.

The examples show how to avoid the 3 common areas where you dates can be
misinterpreted.

The short answer is to use the slash separator and mdy format in SQL and
VBA, but your regional format is fine in the interface.

 

[david epsom dot com dot au]

For clarity, I use and recommend
#yyyy/mm/dd#
in Jet SQL.

(david)