Also if getdate() - 8 days then Next week('2013-04-01 ~~ 2013-04-07)'

All the columns come from single table. But the values need to be fetched like next

week and currentweek.

So two conditions :if getdate()-15 days then currentweek( 'the week flag')

if getdate() - 8 days then nextweek('the week flag')

eg : currentweek(2013-04-01 ~~ 2013-04-07)

nextweek(2013-04-08 ~~ 2013 -04 - 15)