date(tonumber(left({person.date_of_birth},4)),tonumber(mid({person.date_of_birth},5,2)),tonumber(right({person.date_of_birth},2)))

 

After changing to a date format, I was then able to use the difference between the current date and DOB to compute Curr Age, which is a number format:

 

datediff('yyyy',{@DOB},currentdate)-(if datepart('y',currentdate)>datepart('y',{@DOB}) then 0 else 1)

 

 

I am trying to filter out all Curr Age>= 18, but I keep getting the following error:

 

The string is non-numeric and the formula editor highlights the (tonumber(left({person.date_of_birth},4)) part in the formula below, which is the same one above:

 

date(tonumber(left({person.date_of_birth},4)),tonumber(mid({person.date_of_birth},5,2)),tonumber(right({person.date_of_birth},2)))

 

Can someone please help and let me know what I need to change/add to fix this?  Thank you so much.

 

YYYYmmdd, e.g., 19630322

 

Current Date is just 'currentdate'

 

 

Thanks.

 

CONVERT DOB STRING TO NUMBER & COMPUTE AGE:

 

Date of Birth =

Mid ({person.date_of_birth},5 ,2 )+ "/" + Mid ({person.date_of_birth},7 ,2 )+ "/"+ Mid ({person.date_of_birth},1 ,4 )

 

Convert DOB =

local stringvar tcdate;

tcdate :={person.date_of_birth};

date(val(tcdate[1 to 4]),val(tcdate[5 to 6]),val(tcdate[7 to 8]))

 

Age =

INT ( (CurrentDate-{@Convert DOB})/365)