I think that once a month I am going to have to manually open my SQL file and do a text replace on the dates.
That seems the easiest option to me at the moment.
I think this is a case of bad planning on my part (or perhaps just an unforeseen problem I couldn't solve).
Thanks for taking the time though.