Help with expression

[Anonymous]

Hi guys,

I have a date field which I would like to create an expression to look at this field and give me the previous month.

For example

     Month(date_field) -1

But that doesn't work!

So basically if the data is 21/10/2015 I want to get the previous month 21/09/2015

I am interested in the month though and not the actual date.

Hope this all makes sense?!

Thanks !

[settu_periasamy]

Try

Addmonths (date,-1)

[maxgro · Accepted solution]

month(addmonths(date_field, -1))

[ElizaF]

See below. I hope to help you.

Calendar with flags making set analysis so very simple

[Anonymous]

Thanks for your help as always guys!