current and past months
756712May 12 2010 — edited May 12 2010Hi I have one query
I want to create a flag current and past using maximum date available… current will be the latest 12 months and past will be months older than latest 12 months
how to get this?
Date
1 --- 2007-04-01 00:00:00.000 --- Past
2 --- 2007-05-01 00:00:00.000 --- Past
3 --- 2007-06-01 00:00:00.000 --- Past
4 --- 2007-07-01 00:00:00.000 --- Past
5 --- 2007-08-01 00:00:00.000 --- Past
6 --- 2007-09-01 00:00:00.000 --- Past
7 --- 2007-10-01 00:00:00.000 --- Past
8 --- 2007-11-01 00:00:00.000 --- Past
9 --- 2007-12-01 00:00:00.000 --- Past
10 --- 2008-01-01 00:00:00.000 --- Past
11 --- 2008-02-01 00:00:00.000 --- Past
12 --- 2008-03-01 00:00:00.000 --- Past
13 --- 2008-04-01 00:00:00.000 --- Current
14 --- 2008-05-01 00:00:00.000 --- Current
15 --- 2008-06-01 00:00:00.000 --- Current
16 --- 2008-07-01 00:00:00.000 --- Current
17 --- 2008-08-01 00:00:00.000 --- Current
18 --- 2008-09-01 00:00:00.000 --- Current
19 --- 2008-10-01 00:00:00.000 --- Current
20 --- 2008-11-01 00:00:00.000 --- Current
21 --- 2008-12-01 00:00:00.000 --- Current
22 --- 2009-01-01 00:00:00.000 --- Current
23 --- 2009-02-01 00:00:00.000 --- Current
24 --- 2009-03-01 00:00:00.000 --- Current