I have a bit of challenge that I’m wondering if I can solve by SQL.
My source table (thinned out) holds the following two columns:
TASK_NAME [VarChar], DUE_DATE [Date]
My end state is a list (will be a JQM list element) that will list out every task under headings titled as ‘Overdue’, ‘Due Today’, ‘Due Tomorrow’, ‘Due [Monday/Tuesday/Wednesday/Thursday/Friday/etc w/ DUE_DATE appended]’
Example: Heading TASK_NM
**Due Thursday, July 5th, 2012: **
Any help would be greatly appreciated!