Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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,
Use Age() function,
=Age(today(),date(date#(myBirthDate,'MM/DD/YYYY'),'dd/MM/YYYY'))
Regards,
Shubham D