10 days after the last Sunday would be a Wednesday...

Hi Mark!

I'm sure the date logic could be written in a batch script.  But it might be easier, in the script that calls tabcmd, to have a list (or separate file) of dates and check to see if the current date is contained in that list and use that as a condition of whether or not to execute the refresh.  You should be able to find examples of that kind of batch logic online.

I found a SQL script and modified it, so that it generates a list of dates that fits your logic.  I've attached the resulting dates.  You might double check my results.  Here's the SQL script:

SELECT CAST(DATEADD(DAY, 10, (DATEADD(day, DATEDIFF(day,'19000107', DATEADD(month, DATEDIFF(MONTH,0,First_Day_Of_Month), 30))/7*7,'19000107'))) AS DATE)

FROM

          (

                    SELECT '01/01/2013' AS month_date

                    UNION ALL

                    SELECT '02/01/2013' AS month_date

                    UNION ALL     

                    SELECT '02/01/2013' AS month_date

                    UNION ALL

                    ...     

          ) m

Message was edited by: Joshua Milligan I realized you said last Sunday, not Saturday.  I've attached a different file and updated the script inline.

I just noticed you added "business days".  That would change the above a little.