Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
START_DATE | Anniversary of start date in 2012/3 |
---|---|
15/09/2008 | 15/09/2012 |
26/01/2010 | 26/01/2013 |
13/09/2010 | 13/09/2012 |
31/03/2011 | 31/03/2013 |
17/09/2012 | 17/09/2012 |
24/01/2013 | 24/01/2013 |
Hi all,
I have figures for the start date of employees (column 1 above) and need something in the script to work out the anniversary of their start date in the current year. I have used 2012/3 as an example. I am looking to use the date in the first column to find the date in the second column which I do not have.
Any help would be much appreciated as I have been going round in circles on this one
Many thanks
Thank-you so much for your help, works a treat