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 

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Nick
    • Nick
    • 1 yr ago
    • Reported - view

    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

    ---

    Like
  • Thx !! 

    Like
Like Follow
  • 1 yr agoLast active
  • 2Replies
  • 149Views