Date Calculation Problem
Posted: Mon May 14, 2007 7:10 am
I need to schedule a weekly report to run via RoboTask. I have Robotask input the date parameters to the reporting software as follows:
{MonthNo}/{IncDays(-7)}/{Year}{TAB}{Date}{TAB}{DELAY 500}
Everything works fine provided that date in the month is 8 or greater [i.e., May 8th for May]. For the first seven days of May, it seems that robotask cannot interpret that seven days prior to the May date is actually an April date.
For example on May 4th..I really need enter April 27th as the lower reporting parameter. Robotask produces an error. Once I reach May 8th---everything works fine as robotask misses 7 from May 8th and arrives at May 1st.
Is there a way that I can write a formula, so that Robotask can correctly calculate a date in the previous month when the date in the current month is 7 or less [i.e., Correctly calculate April 27 when it is May 4th]? THANKS.
{MonthNo}/{IncDays(-7)}/{Year}{TAB}{Date}{TAB}{DELAY 500}
Everything works fine provided that date in the month is 8 or greater [i.e., May 8th for May]. For the first seven days of May, it seems that robotask cannot interpret that seven days prior to the May date is actually an April date.
For example on May 4th..I really need enter April 27th as the lower reporting parameter. Robotask produces an error. Once I reach May 8th---everything works fine as robotask misses 7 from May 8th and arrives at May 1st.
Is there a way that I can write a formula, so that Robotask can correctly calculate a date in the previous month when the date in the current month is 7 or less [i.e., Correctly calculate April 27 when it is May 4th]? THANKS.