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

null
    • Nick
    • 4 yrs 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

    ---

    • jedrzejfischer
    • 4 yrs ago
    • Reported - view

    Thx !! 

Login to reply

Content aside

  • 4 yrs agoLast active
  • 2Replies
  • 180Views