Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to find the anniversary of a start date in a particular year?

START_DATEAnniversary of start date in 2012/3
15/09/200815/09/2012
26/01/201026/01/2013
13/09/201013/09/2012
31/03/201131/03/2013
17/09/201217/09/2012
24/01/201324/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

10 Replies
Not applicable
Author

Thank-you so much for your help, works a treat