If DateDiff("d", text, Date) >= 0 And DateDiff("d", text2,date) >= 0 Then I am unable to get what this meant in VB? I am trying to get condition where date is between text1 and text2 like date>text1 and date< text2 ...