How can i copy part of a record in a field to another field in same form

[neelsfer]

I have a 13 digit Identity number ie 6302185149081 in the IdNo field. In the same table of this form, is a birthdate field.
I need to copy the above Id number in the following format to the Birthdate field dd/mm/yyyy = 18/02/1963
is this possible?
pls help

[dsatino]

go here and check out the string functions.

http://www.techonthenet.com/access/functions/

The Mid() function is probably the best way to extract what you need.

[neelsfer]

I used =Trim(Left([idNo],Len([IdNo])-7))
and got 630218
I need to swop it around to 18/02/1963
any suggestions?

[dsatino]

mid([idno],5,2) & "/" & mid([idno],3,2) & "/" & mid([idno],1,2)

[neelsfer]

thx dsatino it works