Try:Let([dt = Left ( Filter ( PatientNumber ; 1234567890 ) ; 6 ) ;m = Middle ( dt ; 3 ; 2 ) ;d = Middle ( dt ; 5 ; 2 ) ;y = Middle ( dt ; 1 ; 2 )];date ( m ; d ; y + If ( y < 15 ; 2000 ; 1900 ) ))The patient must be younger than 98
(raybaudi is highlighting the limitation of your method of establishing the date of birth. When you only use two-digit years you cannot determine if '08' is '1908' or '2008'.)
Thanks for the fast responses, fellows. I'll try it and let you know. Bit busy with lots of stuff, today.
@raybaudi, it simply works! Thanks a lot!
@Sorbsbuster, I've never had a patient older than 98, it's cardiac surgery and it would be very unlikely (oldest one ever was 92, never know in the future, of course). But thanks for the info, anyway!
Cheers to you, smart people (making other people smarter),