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

InfoPath Dev

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

Last post 08-07-2012 06:41 PM by brice235i. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 08-07-2012 12:30 AM

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

    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.

  • 08-07-2012 03:55 AM In reply to

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

    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!

    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™


  • 08-07-2012 06:41 PM In reply to

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

    Thank you very much.  Works great!

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.