You could just use numbers to represent the dates. Year runs from 101
to 1231 (thats MDD), and easily create from a date like this:
#month(now()) * 100 + day(now())#. Strings would also work instead of
numbers: "0101" to "1231", and created via #dateFormat(now(),
"mmdd")#.
cheers,
barneyb
> The DBMS that I'm using is MySQL 5.0.
>
> I have a table where I want to store begin and end dates _without_ a year.
> For example, 'Dec 4' through 'Jun 15'. How can I best represent this in
> the database?
>
> I'll be doing selects of the nature
>
> SELECT *
> FROM mytable
> WHERE #today# BETWEEN begindate AND enddate
>
>
>
