Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Try this:
='>=' & MakeDate(Year(Now()), Month(AddMonths(Now(), -3)), 1) & '<=' & MakeDate(Year(Now()), Month(Now()), 1)
Try this:
='>=' & MakeDate(Year(Now()), Month(AddMonths(Now(), -3)), 1) & '<=' & MakeDate(Year(Now()), Month(Now()), 1)
hahahha always something simple
thanks
Difference between your expression and the new expression in a text box object just so you can visualize the difference:
HTH
Best,
Sunny
In what context are you using that conditional. The syntax is wrong for set analysis. Maybe this:
<datefield = {">=$(=MonthStart(now(), -3)) <=$(=MonthEnd(now()))"}>
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