MS Access Query - Date/Month 1

[Pilly170]

hi,

I have year/month data held within a sql server, its held like YYMM, What im trying to do is to run a macro that runs this query that will automatically detect the current year and month eg 0409 for this month. Im pretty sure it would be Date() command but not sure of the syntax, can anyone help??

 

[dhookom]

I think you are looking for a criteria/expression that returns the current year and month in the format YYMM. If so, use the expression:
Format(Date(),"yymm")

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[SkipVought]

Pilly170,

You need to check the Data Type of this field to determine if its a REAL DATE or not.

Let us know.

Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}

 

[Pilly170]

dhookom - you were spot on... cheers!.