Convert Number field to Date field

[cjany]

I have a 4 digit number field (2006) which represents the year. I need to convert to date format so that I can query the current year.

Thanks for any assistance.

 

[rjoubert]

Use this in your query...

WHERE Year([YourDateField]) = 2006

 

[cjany]

No. I don't want to always have to enter the year. I want the query to always pull whatever the current year is.

 

[rjoubert]

WHERE Year([YourDateField]) = Year(Now)

 

[PHV]

Where [your 4 digit number field] = Year(Date())

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[cjany]

HHMM no that's not working. Remember this field is currently a number data type and I want to convert it to a date type.

 

[rjoubert]

So this 4 digit number field is in your table, and you want to query for records that match the current year? If that's the case PHV's post should do the trick. You wouldn't need to convert the field to a date/time data type.