Date Format

[KalEl33]

I would like to get the year part of a date from table called tblTempDate. I would then like to add "January" to the front of the year inorder to run a query using the new date (e.g. January 2000). I've tried using the following as the query criteria, but I get a mismatched type error.

= Format("January " & DatePart("yyyy", ([tblTempDate].[TempDate])), "mmmm yyyy&quot

Any ideas on how to grab the year part of a date, then convert that date into "January year"? (E.g. TempDate = May 2002, the result I'm looking for is January 2002.)

Thanks in advance for your help.

Sincerely,
Kal-El

 

[krispi]

Try this: create your query based on your form. In the first column of the query, type in the 'Field:' row:

NewDate: "January " & DatePart("yyyy", [tblTempDate]![TempDate])

It seems to work, hope it helps,

Chris