Calculating number of years from a date provided in a file and todays date

OL Connect Professional
1

Hi,
I have recieved a job where I need to calculate the number of years a customer has been a member of a club and use this as a variable text in a greeting-card. With the records (txt-file) there is a column that contains the member start date. I only need to calculate the years from member start year to the current year.
is this possible to do in the datamapper or in workflow?
Has anybody done this and have a nice solution ready?

2

I found the following on the web and used it in OL Connect Designer:

function calculateAge(birthday) { // birthday is a date
   var ageDifMs = Date.now() - new Date(birthday);
   var ageDate = new Date(ageDifMs); // miliseconds from epoch
   return Math.abs(ageDate.getUTCFullYear() - 1970);
}

results.text( calculateAge( record.fields.bd ) );

Hope this helps,

Erik

image
image1358×358 77.1 KB

3

Implemented the same logic in Data Mapper, see the attached data mapper config file.

age.OL-datamapper (3.2 KB)

Erik

image
image1702×907 157 KB

4

Thank you Erik for your time and effort, I will certainly try this at my end.