Month Variable

[system]

I have ‘Case Date’ column which gives result as:

10/01/2008
11/10/2008
01/05/2009
10/05/2009
11/07/2009

I am told to get data monthly.

But If I use Month() function on ‘Case Date’, it gives me data for that particular month of both 2008 and 2009 together. How can I display monthly data only for a particular year ?

---

Developer_Designer (BOB member since 2009-08-09)

[system]

But If I use Month() function on ‘Case Date’, it gives me data for that particular month of both 2008 and 2009 together. How can I display monthly data only for a particular year ?

Good Day,

try using Where() function in your formula to filter your year.

Regards,
-John Vincent

---

jvmauricio (BOB member since 2009-08-03)