How to query by date format yyyy-mm-dd?

Hi guys

I have a query where I was using

DateSerial(Year(Date()),Month(Date()),0)

to pull all records for the prior month, it worked find until they changed the date from mm/dd/yyyy to yyyy-mm-dd, I can't seem to find the right code to pull up the correct records.

Try using...

Format(DateSerial(Year(Date), Month(Date), 0), "yyyy-mm-dd")

Short text... so you can't use numeric comparison operator.

What you can do is use SQL side query to convert column then use numeric operator on the expression.

Something like below, assuming it's MS Access.

Select Column1, DateValue(ShortTextDateColumn) as [NewName] FROM Table
Where DateValue(ShortTextDateColumn) <= SomeDateValue

EDIT: 'can' should be can't in first sentence. Fixed.