Hi everyone,
I want to get result in query for cut off (Year end) date for my employees hire date the year they join i want that year's last date.
I have date field called [HireDate] i want the result in another column which is 1stYearEndDate: to show the 31/12/## of [HireDate] field's date.
for example : if [HireDate] is 05/02/2012 then it should give me result 31/12/2012
Please provide the function and criteria.
I try following but not able to achieve the result.
Date([HireDate]) = Year(Date())
I want to get result in query for cut off (Year end) date for my employees hire date the year they join i want that year's last date.
I have date field called [HireDate] i want the result in another column which is 1stYearEndDate: to show the 31/12/## of [HireDate] field's date.
for example : if [HireDate] is 05/02/2012 then it should give me result 31/12/2012
Please provide the function and criteria.
I try following but not able to achieve the result.
Date([HireDate]) = Year(Date())