Forum Discussion
Calculate date difference
Hi Community, I'm trying to calculate the date difference between the bold dates: Client_NR Sit_NR Mutation Input Start Date End Date 1 1 NW 1-3-2015 1-4-2015 28-2-2016 1 ...
Hi Phil_Seamark,
Yes, that's right. The date I want to create is the difference between the startdate of mutation = NW and the inputdate of the mutation = SC
Are there always just 2 rows, or are there subsequent SC rows that you would also like a DATEDIFF calculated for?
The mutation column can have up to 6 different values. The client will always hav the NW mutation, but not necessarily one of the others. I only want to calculate the date difference if both mutations NW and SC are available for the client.