bluedollar
Programmer
I have the following record:
TID = primary key
week_no = integer
year = integer
What I would like to do is select a range of records which are greater than:
week_no AND year
and less than
week_no AND year
For example records that are after week number 10 year 2003 and before week number 40 year 2004.
The users of the database do not want to use the date format to this.
Is this possible?
Any help would be greatly appreciated.
Thanks
Dan
TID = primary key
week_no = integer
year = integer
What I would like to do is select a range of records which are greater than:
week_no AND year
and less than
week_no AND year
For example records that are after week number 10 year 2003 and before week number 40 year 2004.
The users of the database do not want to use the date format to this.
Is this possible?
Any help would be greatly appreciated.
Thanks
Dan