>Is there a quick way to find the last date in any given month. I need to select records that fall within the selected month and year. I was going to use the between() command but how can you select the last date of a month (28,30,31) without lines of code?Build the first day of next month with something like DATE(nYear,nNextMonth,1) then subtract 1
Here, I found one for you, plus a discussion of what works best:
http://fox.wikis.com/wc.dll?Wiki~LastDayOfMonth