topic date format in QlikView

date format

collinsjames — Thu, 04 Apr 2019 09:44:19 GMT

today()-(date(date#({<Ref_Patient_RD_US.birth_dt),'mm/dd/yyyy'),'dd/mm/yyyy'='11/15/1924'>})

am getting a syntax error,in above expression,how to resolve this.

Shubham_Deshmukh — Thu, 04 Apr 2019 10:18:00 GMT

What you want to do here?

collinsjames — Thu, 04 Apr 2019 10:23:36 GMT

actually I want to calculate the age ,

so I am subtracting today date(dd/mm/yyyy) and my birthdate field(mm/dd/yyyy) to get the age,

Shubham_Deshmukh — Thu, 04 Apr 2019 10:48:57 GMT

Use Age() function,

=Age(today(),date(date#(myBirthDate,'MM/DD/YYYY'),'dd/MM/YYYY'))

Regards,

Shubham D