Hi!



I want to select distinct month from the database table. How can i do that anyone can help me.

my database table records are as



Transaction_Date(mm/dd/yyyy)

01/01/2009

01/15/2009

01/25/2009

02/05/2009

02/20/2009

02/29/2009

03/10/2009

03/15/2009

03/28/2009

04/15/2009

04/22/2009

04/27/2009



using where statement less than today(05/01/2009) date



example

month

01

02

03

04






Max