i've vf page where a pick list values as today,lastweek,lastmonth,next day etc and a field interview_date__c. i want to display records where interview date__c=today(or)lastweek. can any one solve this dinamically
my code is
counselor=[Select Name,Course_Fee__c,Feedback__c,Lead_Enquired_On__c,
                   Lead_Mobile_Number__c,Lead_Name__c,Status__c,Trainer_name__c,
                   Counselling_date__c from Counselling__c 
                   where Counselling_date__c=:today];
it's working 
but i want this as dinamic as
i take a string date and i want to give it as Counselling_date__c=:date....
help me in this case
thanks in advance

trigger candidatescheduleforinterview on schedule__c (after update) 
{
    LIST<schedule__c>lstsch=new list<schedule__c>();
    List<Follow_Up_2__c>lstfu2=new list<Follow_Up_2__c>();
    for(schedule__c sc : trigger.old)
    {
        if(sc.Follow_up_1__c=='Answered/Intrested')
        {
            lstsch.add(sc);
            follow_up_2__c fu2= new follow_up_2__c();
            fu2.Name=sc.Name;
            fu2.Domine__c=sc.Domine__c;
            fu2.EMail_ID__c=sc.EMail_ID__c;
            fu2.LastName__c=sc.LastName__c;
            fu2.Mobile__c=sc.Mobile__c;
            lstfu2.add(fu2);
        }
    }
    if(lstsch.size()>0)
    {
        insert lstfu2;
        delete lstsch;


i want delete record in schedule object and insert it in followup2 object can any one help me in it?

trigger candidatescheduleforinterview on schedule__c (after update) 
{
    LIST<schedule__c>lstsch=new list<schedule__c>();
    List<Follow_Up_2__c>lstfu2=new list<Follow_Up_2__c>();
    for(schedule__c sc : trigger.old)
    {
        if(sc.Follow_up_1__c=='Answered/Intrested')
        {
            lstsch.add(sc);
            follow_up_2__c fu2= new follow_up_2__c();
            fu2.Name=sc.Name;
            fu2.Domine__c=sc.Domine__c;
            fu2.EMail_ID__c=sc.EMail_ID__c;
            fu2.LastName__c=sc.LastName__c;
            fu2.Mobile__c=sc.Mobile__c;
            lstfu2.add(fu2);
        }
    }
    if(lstsch.size()>0)
    {
        insert lstfu2;
        delete lstsch;


i want delete record in schedule object and insert it in followup2 object can any one help me in it?