Expression to calculate age from DOB in Qlik

[Kushal_Chawda]

@smanas  check out age function

https://help.qlik.com/en-US/qlikview/May2024/Subsystems/Client/Content/QV_QlikView/Scripting/DateAnd...

[smanas]

@Kushal_Chawda Thank you - Issue is that Date is in the MM/DD/YYYY format is there an expression to change that? Thank you for your help

[Kushal_Chawda]

@smanas  Date format doesn't matter unless it is proper date (not text). It will calculate age correctly. If you want to convert it to some other format Date#() or Date() function.