Chala_Chase - profile

Chala_Chase · Apr 11, 2020

Hi i am in New Zealand and our date format is dd,mm,yyyy and I am trying to calculate years and months using this code: DATETIME_DIFF(TODAY(), {Date Of Birth}, ‘years’) & ’ years, ’ & MOD(DATETIME_DIFF(TODAY(), {Date Of Birth}, ‘months’), 12) & ’ mon...

Chala_Chase · Apr 11, 2020

Oh great I have changed the Date format thank you so much that worked

User Statistics

User Activity

Different date format dd,mm,yyyy to calculate age

Re: Different date format dd,mm,yyyy to calculate age