Date

[Paul1981]

Hi,

I have a field (T1) which contains years (ie 1956), but crystal sees this as a text field.

How can I convert it to a number and then take the current year away from it to get someones age??

I understand the age wont be exacet without the month and day.

Thanks

 

[synapsevampire]

Try:

year(currentdate) - val({table.year})

-k

 

[Paul1981]

Thank you!! that worked!!