A possible way to solve this issue is to join your data to a calendar table using date as key, if you can provide more information e.g. sample data or workbook will be more easier to provide step by step solution.
Hi Zhouyi Zhang,
Thanks very much for the suggestion - I was hoping not to go through that route- i know it is just a single once off bit of work and will resolve all issues going forward,
Do you know where I could get an excel spreadsheet or a text file that I could import into my DB containing YMD data?
It has been a very long day
Thanks very much - let me rather go this route