Query criteria

[Chris]

I fear this is a dumb question, so apologies in advance. For the life of me,
I can't get anything to work.

I need to figure out a simple formula for a criteria to drive a query. I
have two seperate date fields (C_Month and C_Year). Month is shown as 01,
02, etc and Year is 4 digit year. Both are text fields...

The criteria I need is to select ONLY the current month/year based on when
the query is run - so for today, i'd only want Aug 09 records.

Thanks in advance for any help...

 

[KARL DEWEY]

You should use a REAL DateTime field and display it as needed.
Your fields -- C_Month C_Year
Criteria -- Format(Date(),"m") Format(Date(),"yyyy")

 

[CraigH]

Format(Format(Date(),"m"),"00") for Karl's example for month since you need
01 for January

 

[KARL DEWEY]

Or use --
Format(Date(),"mm")

 

[Dale Fye]

Actually, Format(date, "mm") would work as well.