8 Replies Latest reply: Mar 27, 2017 7:12 AM by Ankit Gupta RSS

    Converting Age providing negative counts

    Ankit Gupta

      Hi All,

       

      I have a data of Patients Date of birth in the format DD-MMM-YY that I am converting first into the Age and then creating Age Groups using Class() function, script is below:

       

      LOAD

      [PATIENT_BIRTHDATE],

      Age(today(),[PATIENT_BIRTHDATE]) as [Patient Age],

      Class(Age(today(),[PATIENT_BIRTHDATE]),10,'Age Range') as [Patient Age Group],

       

      The output that I am getting have negative Age counts, which is not correct, DOB I have check and its valid, I am not sure why converted data showing negative Age(s). This is impacting the Age Groups as well that I am creating further.  Please see the below screen shot.

       

      Can someone please help me and troubleshot why this weird Output?

       

      AGE.png