Hi, I am using InfoPath 2003. I am creating a request form and I would like to have a RequestID field that uses a format such as:
C/yyyy/mm/xxx
The C and the /'s are hardcoded. I have figured out how to fill in the yyyy and the mm. Currently my formula looks like this:
concat("C/", substring(today(), 1, 4), ...