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