0
How to make birth date from text field ?
Hi all,
I'm new user of Ninox Community. I have question about extracting birth date from text field. I was searching, but there was no thread like this. In Poland we have our identity number ("Pesel") which is formed by 11 digits. First 2 means year ; next 2 - month ; next 2 - day; other are not important
2 replies
-
Create a formula field with this code:
---
let d := substr(Pesel, 4, 2);
let m := substr(Pesel, 2, 2);
let y := substr(Pesel, 0, 2);
d + "/" + m + "/" + y---
-
Thx !!
Content aside
- 3 yrs agoLast active
- 2Replies
- 177Views