Search results

well Rickster's solution works damn well without any IIF's :) I'm owing you beer, dude! :) Where should I send you a box of it?

Thanks! I knew how to do that in form but didn't know how to do that in query :) What I entered in form field to get the birth date is this: =DateValue(IIf(Left([personal_ID];1)<5;1900+Mid([personal_ID];2;2) & "." & Mid([personal_ID];4;2) & "." &...

Don't need help, I already found a way how to do that :D hiphip hurray!

Hello, I would appreciate if someone could help on this problem. What I want to do is to add a field in a form that would automatically show the date of person's birth after entering the persons ID. For example, I enter 39101012345. The first number (3) shows only the gender so I don't need it...