date format

[collinsjames]

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]

What you want to do here?

[collinsjames]

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]

Use Age() function,

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

Regards,

Shubham D