Not a question this time, just an observation of apparent weirdness.
I posted a question awhile ago which prompted a thread about Day /
DayOfMonth in SQL.
I've run across code which had a similar functionality and ran up against
the same problem.
That is, I wrote this line into an SQL query :
AND Day(YAppDate) < #Day(Today_Date)#
which doesn't work, then tried
AND DayofMonth(YAppDate) < #DayOfMonth(Today_Date)#
which also doesn't work. What does work is this :
AND DayOfMonth(YAppDate) < #Day(Today_Date)#
Yep, DayOfMonth on one side and Day on the other. DayOfMonth is supposed
to be a straight alias, but doesn't quite seem to be acting that way.
FYI :
YAppDate is read from the Db, and is in date/time format
Today_Date = DateAdd("m", 0, Now())
---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004
