I actually just thought of this, I back tracked, and as mentioned in my question post, the 1/2015 was created from an original [Dt] field - which is in Date format.
I tried
< 1/1/2015, since the records will be the same for the calculated [Date] field that is in Short Text format. However, the records with dates less than 1/1/2015 are still not deleted.
Hope this makes sense.
exp vg
ASKER
Got it to work by deleting from the source date file that the new date field was formatted off of.
I tried this
Where Format([Date],"m/yyyy") < "1/2015"
And got an error on syntax.