Wednesday, 30 September 2009

Getting your age from your IC number

(Year(Today())) - ((Combine(19, Left(RHBKKK._03_IC, 2))))

Which doesnt handle anyone if they're born on yr 2000 or higher, will need an if statement for that.

1 comments:

maxcobmara said...

lot of help on approach here
http://jabrown.customer.netspace.net.au/approach/index.htm