Access Expression - between two dates

Will my expression at the bottom work?  
I am concerned that I need some date operator or function before each of the two dates.
Thank you.

Tom


[ Customer]![Type]="MassDiscount" And [Transaction Table]![Date] Between "10/01/2008" And "09/30/2011"
ThomasJueAsked:
Who is Participating?
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPConnect With a Mentor Commented:
You should use the date delimiter of # like this:

[ Customer]![Type]="MassDiscount" And [Transaction Table]![Date] Between #10/01/2008# And $09/30/2011#

Assuming that  [Transaction Table]![Date]  is a date/time data type
0
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
yes you need the "#" as wrapper

[Customer]![Type]="MassDiscount" And [Transaction Table]![Date] Between #10/01/2008# And #09/30/2011#
0
 
ThomasJueAuthor Commented:
Both answers excellent.  Thank you.
0
All Courses

From novice to tech pro — start learning today.