Hi all,
1 = Monthly 3 = Quaterly
Schedule_T
Date | Frequency
2009-11-13 | 1
2008-01-01 | 3

Based on the above data, for the first record, every month on 13th there will a reminder

Based on the above data, for the second record, every quaterly i.e the next would be 2008-04-01 there will a reminder and this would continue on and on

I want a query which will take today() as the date to compare and find if there is any reminder for the above two records

How can this be done

Thanks