Selecting Last 3 months

[samuel_brierley]

Hi all,

Can anyone see where im going wrong with the below expression to select the last 3 months?

='>='&MakeDate(year(now()),AddMonths(now(),-3),1)&'<='&MakeDate(year(now()),month(now()),1)

[sunny_talwar · Accepted solution]

Try this:

='>=' & MakeDate(Year(Now()), Month(AddMonths(Now(), -3)), 1) & '<=' & MakeDate(Year(Now()), Month(Now()), 1)

[samuel_brierley]

hahahha always something simple

thanks

[sunny_talwar]

Difference between your expression and the new expression in a text box object just so you can visualize the difference:

HTH

Best,

Sunny

[jonathandienst]

In what context are you using that conditional. The syntax is wrong for set analysis. Maybe this:

<datefield = {">=$(=MonthStart(now(), -3)) <=$(=MonthEnd(now()))"}>

[sunny_talwar]

Hahahaha yup

I am glad we were able to quickly figure it out. I suggest closing this thread by marking the correct answer and any helpful answers.

Best,

Sunny