1

I am trying to change the filename date format for an InfoPath form generated item.

Currently I am using this file name formula: concat("Backup", "-", today())

Which results in this filename Backup-2015-02-12

However having changed my locale settings to United Kingdom the date format has changed for another field on my form but not on this one.

I need the file name to display as Backup-12-02-2015

Thanks.

3

if you want date format in dd-mm-yyyy format although you changed local settings to United Kingdom you can use below formula:

concat("Backup", "-", substring(now(), 9, 2), "-", substring(now(), 6, 2), "-", substring(now(), 1, 4))
  • Brilliant, this is the solution I was looking for! :) – surfnode Feb 12 '15 at 11:15
  • If it answers your question, mark it as answered by ticking the check mark. – Eric Alexander Feb 12 '15 at 13:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.