Re: Dates and the 'Between' predicate
From: Marshall Barton (marshbarton_at_wowway.com)
Date: 03/17/05
- Next message: Jenny Nunemacher: "Re: Help with a "most recent of each" type of query?!"
- Previous message: Tom Wickerath: "RE: Please Help with creating (what I call) a Dynamic Query"
- In reply to: Pete: "Re: Dates and the 'Between' predicate"
- Next in thread: Pete: "Re: Dates and the 'Between' predicate"
- Reply: Pete: "Re: Dates and the 'Between' predicate"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 17 Mar 2005 12:10:49 -0600
Pete wrote:
>However, I am curious as to how Marshall's solution works (with all the
>Hieroglyphics) ;-)
All the format function does is explicitly convert the date
value to a standard USA date literal. The \ is the Format
function's "escape" character, which means the next
character is to be used as is. The #'s identify a date
literal value and the / characters are "escaped" as literals
because your Windows locale settings may specify that / be
changed to some other non-USA date separator. If you try
the Format function, you'll see that the result is an
unambiguous USA date literal such as #3/17/2005#.
Criptic it is, but once you understand the various
formatting code characters (see Format Property in Help),
fairly easy to decipher.
-- Marsh MVP [MS Access]
- Next message: Jenny Nunemacher: "Re: Help with a "most recent of each" type of query?!"
- Previous message: Tom Wickerath: "RE: Please Help with creating (what I call) a Dynamic Query"
- In reply to: Pete: "Re: Dates and the 'Between' predicate"
- Next in thread: Pete: "Re: Dates and the 'Between' predicate"
- Reply: Pete: "Re: Dates and the 'Between' predicate"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
