Calculation of Age vs DoB

[AlanKang]

Hi All, I am new to Alteryx.

I am struggling on how to calculate the age vs DoB. 

I saw a same question was posted on the discussion before. However, the Age is appears as NULL. 

I have attached the DoB excel file below. The results workflow mentioned DATETIMEDIFF2: "xxxxxxxx" is not a Valid Date or Time.

I would appreciate it if anyone of you can help with me on this.

note: The type of DoB in the original file is V_String. 

Thank you.

[Gaurav_Dhama_ · Accepted solution]

You need to just change the format of the date and then take the difference, Attached is the workflow with 2 different approaches.

[AlanKang]

Thanks Gaurav for the helps! It's work!