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

problems dealing with dates in my queries/SQL code

P: n/a
I'm having problems dealing with dates in my queries/SQL code.
I need a search digit date. In form define date field without format I
receive results.
But I go to define date filed with short date format I receive error. In my
regional settings are in the format "dd.mm.yyyy".
What I need to do?
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Igor Kramarsich - EDIT wrote:
I'm having problems dealing with dates in my queries/SQL code.
I need a search digit date. In form define date field without format I
receive results.
But I go to define date filed with short date format I receive error.
In my regional settings are in the format "dd.mm.yyyy".
What I need to do?


Date literals in Access queries must be either in a non-abiguous format (ISO
or month in alpha) or in U.S. formats mm/dd/yyyy or mm/dd/yy.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.