General

Re: Submit Data Connection - File Name includes value of a Date Field, but only the YEAR

brice235i — Wed, 08 Aug 2012 01:41:58 GMT

Thank you very much. Works great!

Re: Submit Data Connection - File Name includes value of a Date Field, but only the YEAR

ErnestoM — Tue, 07 Aug 2012 10:55:41 GMT

Try this:

substring(today(), 1, 4)

today() returns today's date with the year as the first four characters, so substring selects just those first four characters.

Good luck!

Submit Data Connection - File Name includes value of a Date Field, but only the YEAR

brice235i — Tue, 07 Aug 2012 07:30:36 GMT

Hi there, I am trying to add the year to form file names displayed in a Sharepoint library. The problem is, that I'd only like to display the year. Does anyone know how to do this?

concat("Expense Form-", Cost Code, "-", Date, "-", FormNumber)

Alternatively I could ask the user to manually input the year, but would be good if there is a way to do this automatically.

Thank you.