https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/121175.aspxMon, 24 Jun 2019 15:49:24 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121175lucky4anshh0https://www.infopathdev.com:443/forums/thread/121175.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=121175Worked... Thanks :Dhttps://www.infopathdev.com:443/forums/thread/121174.aspxMon, 24 Jun 2019 15:43:29 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121174Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/121174.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=121174concat(YourFieldHere, substring(translate(now(), "_-:T", ""), 3, 5))https://www.infopathdev.com:443/forums/thread/121172.aspxMon, 24 Jun 2019 14:54:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121172lucky4anshh0https://www.infopathdev.com:443/forums/thread/121172.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=121172I want to use the below formula with concat. I want to add a field before it and then the substring formula. If you could help creating it for me? substring(translate(now(), "_-:T", ""), 3, 5)