Hi,
I"m trying to create a Split file which will select the last month's worth of minutely data, with the intention of having it run automatically at the start of each month to compile the last month's data into a single csv.
I cannot get the start condition to work properly and it seems to not work as I would expect it to.
The start condition:
1[2013]:1[12%1]::
correctly starts the data being processed on 2013-12-01 00:00. (This data point definitely exists)
The start condition:
1[2013]:1[-1%1]::
which from my understanding should select the first day of the last month in 2013 (I suspect this is where I'm wrong), does not work as it starts processing at 2013-12-02 00:00.
Where am I going wrong? Also if there are any easier alternatives to doing it this way I'm happy to hear about them.
Thanks,
Sam