At 07:59 PM 3/3/2005, Doug Hamilton wrote:
... we just need a list of birthdays in a date range,
like who has April birthdays ...
Doug,
Here's how:
01. Keep the actual birthday in its original column
02. Now if you need to know the birthday of all kids,
next month, such as March, regardless of the actual
year, try the following:
Example:
SET VAR vMonth INTEGER = (IMON(ADDMON(.#DATE,1)))
SELECT LastName, FirstName FROM tablename WHERE +
(IMON(DateOfBirthColumn)) = .vMonth
That should give you the list of all kids with
their birthday in March.
Use that logic to achieve your goal, as above, if I
understand correctly.
Hope that helps!
Very Best R:egards,
Razzak.
