Comparing Date with current Date

[ds_8805]

Hi Everyone. I have a table and one of the fields is a date field. I need to create a query based on this table such that only records from the current year is displayed. So I need to retrieve the year part from the
date and compare with the current date. I m not too sure on how to do this esp the retrieving of year part from the date. Hope someone could guide me on this! Thanks

[pbaldy]

You can use the Year() function to get the year from both.

[ds_8805]

Hey thank you very much! works perfectly fine!

Year([Fieldname])=Year(Date())

[pbaldy]

No problem, happy to help.

[ds_8805]

sorry I have another doubt regarding this. The thing is in another form, I could like the report to display records that have have the same year as the one the user inputed in the form. Therefore I wrote a criteria in the query ( which the report is based on). This is what I wrote:
Year("PODate")=[Forms]![ContentPage(Opex)]![Year]

However, it is giving an error msg saying either the expression is wrong or too complex. Could someone guide me on what I might be doing.

Thanks

[pbaldy]

Not sure where you're using it, but almost certainly you don't want the quotes around the field name:

Year([PODate])=[Forms]![ContentPage(Opex)]![Year]

[ds_8805]

ohhhh I just realised my mistake! that solved the problem! Thanks alot!

[pbaldy]

No problem, glad we got it sorted out.