How to store a dynamic date as a date variable
Posted on 2012-08-29
I'm trying to construct dates which I can store in variables as dates. The dates themselves will be variable as they are based on different points in the academic year.
For this year, the dates will be (UK format):
These will need to change in future years. I've tried manipulating using DatePart and it has the right numbers in, but isn't in date format, e.g. 31/12/2012 comes out as 31122012. Is there any way I can convert this to a date so that I can use the variable to compare against cell contents?
I'm awarding 500 points for a simple answer, but won't be able to look at it again until tomorrow morning.