Yeah, the worst part about using JAN-07 for a date and then using it to find a range of dates is that there isn't any indicator of whether or not JAN-07 should "JAN 1, 2007", "JAN 31, 2007", "JAN 1, 1907", or "JAN 31, 1907".
With four possibilities for each one date, I'm almost positive it would be nearly impossible to find some kind of date range using an expression alone. If you could do it, the expression would be extremely long and complicated.
It could be done in VBA, but you still have the problem of determining if the parameters you use for the date ranges should be the 1st of the month or the last day of the month AND you have to calculate what the last day of the month is since January will have 31 days and February will have 28 (sometimes 29) days.
|