On Sep 20, 2007, at 2:43 PM, Ed Leafe wrote:
>
> Date/time functions are documented at http://dev.mysql.com/doc/
> refman/5.1/en/date-and-time-functions.html ( -or- http://tinyurl.com/
> fl5wn )
Well, that is what I wanted to shred. I just couldn't figure it out.
> WHERE YEAR(<field>) = YEAR(NOW())
I swear I tried that one....
I am getting it better now. I don't know what was going on with my
brain that day. You helped kick my brain in the a$$. Thanks, Ed.
To "get over it" (and because it is just darn useful), I am
reproducing an old, favorite VFP function of mine that turns a common-
language date range ("Next Week") into the date values. Lots of date
calculations for me to drill myself on...
Ken
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
