Macro to Actions Issue (Last 12 Months select )

[#1]

We are in process of migrating QV report from Version 8.2 to 9. When we move report to version 9, we want to eliminate macros as much as possible. So far I am able to produce desired behavior using "Actions" and removing macros. However I am having trouble in converting following macro to actions in version 9.

sub Lock

set y=ActiveDocument.GetField("Date")

y.TOPSelect "Date",12

end sub

How do I make sure search string always selects last 12 months?

[Anonymous · Accepted solution]

Here's an example using Actions instead of a macro to select the last 12 months from a YearMonth field.

[#3]

How do I select the last twelve months.

My formula is:

='>' & date(addmonths((date(Today(),'YYYY')&MaandMin1-1),-12), 'YYYYMM')

He selects the last month when I use the formula

=(date(Today(),'YYYY')&MaandMin1-1)

But he was nothing when I select the entire formula

Who can help me with this?

[#4]

I am using following formula and it is working fine for me. Can you try it ?

= '>' & MonthStart((Today()),-12)

[#5]

don't work by me

[#6]

=(date(Today(),'YYYY')&MaandMin1-1)

This one works, but i want the past 12 months