On Sun, Jun 28, 2009 at 1:52 PM, Adam Rich ada...@sbcglobal.net wrote:
Hello,
I have a table with a DATE field birth_date. The data obviously contains
various dates in the past, such as 07/04/1970. In my query, I need to
retrieve the person's next birthday. In other words, for the example
Guy Flaherty wrote:
On Sun, Jun 28, 2009 at 1:52 PM, Adam Rich ada...@sbcglobal.net
mailto:ada...@sbcglobal.net wrote:
Hello,
I have a table with a DATE field birth_date. The data obviously
contains various dates in the past, such as 07/04/1970. In my
query, I need to
Adam Rich wrote:
Guy Flaherty wrote:
You could use the extract() function to calculate the day of year of
the person's birthdate and then check if this number is within today's
day of year and range of days you want to check for, for example,
today's day of year + 30 days to be within a
