H
Howard
I have tried doing this for a while but can't get my head around the
change of year on 31st Dec.
Can anyone offer an elegant solution to a criteria satisfying the follwing.
From a date/time field called IncidentDate I need to extract those
records falling between today's date a year ago and the 1st September
before that.
ie
if today is 10th Oct 2009 I want records from 1st September 2008 to 10th
Oct 2008
but if today was 3rd January 2010 I would want those from 1st September
2008 to 3rd January 2009 because the range spans two different years.
Without wrtiting a length UDF what is the best way to do it?
Howard
change of year on 31st Dec.
Can anyone offer an elegant solution to a criteria satisfying the follwing.
From a date/time field called IncidentDate I need to extract those
records falling between today's date a year ago and the 1st September
before that.
ie
if today is 10th Oct 2009 I want records from 1st September 2008 to 10th
Oct 2008
but if today was 3rd January 2010 I would want those from 1st September
2008 to 3rd January 2009 because the range spans two different years.
Without wrtiting a length UDF what is the best way to do it?
Howard