Hi I am visting to create a macro variable on a accumulating financial year period, so that each month it will automatically select a date range based on the time period as we progress through the year. ie if it is Sep12 then I want to select records with a drawn date for Jul12 to Aug12, Jul11 to Aug11 or if its Feb13 then I want to select records for Jul12 to Jan13, Jul11 to Jan12. Thanks for your help in advance.
... View more