Need to select two months prior to current month without using prompt
Summary
I need to create a scheduled analysis that pulls records with enterprise hire dates two months priorContent
I have an analysis that currently has a prompt that pulls enterprise hire dates that fall between the To and From dates. I run this each month, export to excel and send to the user. I want to change this so that I can create a scheduled analysis to automatically send the report to the user. I need to pull any records with an Enterprise Hire Date that is within two months prior to the current month. Meaning, if I run the report as of today (12/27/17), I would put in my prompt a From Date of 10/1/17 and a To