I have a DATE field "Target Date", which I have values for.
I want to create a new DATE column in my access query called "Validation Date".
The "Validate Date" will equal the last day of the year 12/31/2016, 2017, 2018, etc., and is based off of the "Target Date". If the "Target Date" is within the year 2014, the "Validation Date" will be the following year end date, 12/31/2015.
I.E. If the "Target Date" is any day within 2015....the "Validation Date" will be 12/31/2016.
I.E If the "Target Date" is any day within 2016....the "Validation Date" will be 12/31/2017.
I want to create a new DATE column in my access query called "Validation Date".
The "Validate Date" will equal the last day of the year 12/31/2016, 2017, 2018, etc., and is based off of the "Target Date". If the "Target Date" is within the year 2014, the "Validation Date" will be the following year end date, 12/31/2015.
I.E. If the "Target Date" is any day within 2015....the "Validation Date" will be 12/31/2016.
I.E If the "Target Date" is any day within 2016....the "Validation Date" will be 12/31/2017.