Connecting Tech Pros Worldwide Help | Site Map

problems dealing with dates in my queries/SQL code

Igor Kramarsich - EDIT
Guest
 
Posts: n/a
#1: Nov 13 '05
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?


Rick Brandt
Guest
 
Posts: n/a
#2: Nov 13 '05

re: problems dealing with dates in my queries/SQL code


Igor Kramarsich - EDIT wrote:[color=blue]
> 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?[/color]

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


Closed Thread