Access - Delete Dates Cells Formatted as Short Text

Since the format of the date field I created was m/yyyy

I tried this

Where Format([Date],"m/yyyy") < "1/2015"

And got an error on syntax.

try the other format i posted above


where format([date],"yyyymm") < "201501"

I want to delete the fields less than < 1/2015

Thank you.

Forgot to mention - I tried the first one first - and received the same syntax error. I then tried the one I created to see if that would work.

Both did not.

you can NOT delete a field only with criteria, you will be deleting the RECORD.

you can DELETE the values of a field. By setting the value to NULL or a empty string ""

what you posted is not the same as i have posted. Look carefully

Let me clarify - delete the record where this date criteria is met.

I tried the one you posted as well.

Both did not work.

This is what I tried from you:

where format([date],"yyyymm") < "201501"

upload a copy of the db.

Unfortunately I cannot - this is sensitive data.

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.

Got it to work by deleting from the source date file that the new date field was formatted off of.

I do thank you for your suggestions.