Query criteria

[cbende2]

Hello all,

I have text field that is storing both dates, and "N/A."

I'm trying to to get only records that match this format "mm/dd/yyyy" or "xx/xx/xxxx"

Are there any format functions for query criteria, like must match this format "__/__/____" ?



I know I can just use "<> "N/A"" however I want "<> "N/A" AND Format = "__/__/____"

Is there anything like this?

Thanks

[cbende2]

Figured it out

Expression1: IsDate(MyField)
Criteria: Yes

[JoeM]

Just note that "IsDate" will check for any valid date format, not just "mm/dd/yyyy", in case that is important to you.

[cbende2]

That's even better, Thanks Joe for the response!