0

Text

Hi

i have one field that it is text. I write to this text number. For example: 970812.   I want when i write this number,after write show me 97/08/12

Can i do? If yes, where should i write formul for it

 

tnk

2 replies

null
    • Nick
    • 6 yrs ago
    • Reported - view

    Create new formual field and use this code:

     

    substr(yourTextField, 0, 2) + "/" + substr(yourTextField, 2, 2) + "/" + substr(yourTextField, 4, 2)

     

    Nick

    • New_Sun
    • 6 yrs ago
    • Reported - view

    thank you. it is ok

Login to reply

Content aside

  • 6 yrs agoLast active
  • 2Replies
  • 1279Views