I am have tried setting up a formula to extract the date of birth from the first 6 characters starting from right to left
Eg 840723008147 after extraction should be 23/07/1984
200120305195 after extraction should be 20/01/2020
I need to se to the year as four characters, but the ID for the yea is only two characters
It would be appreciated if someone could assist me
Bookmarks