InfoPath Dev

Hi, my problem is:

I create a form, with a field Date - today().

It returns, for example, in form 10/03/2014

but, when save, in xml file, appears: 2014-10-03

i need format dd/mm/yyyy . our system don't accept other.

infopath 2010

Hi cimerio,

Is it possible for you to use a hidden field instead, with a substring formula to format the date as dd/mm/yyyy? In order to get the desired format, I would suggest setting the hidden field's default value or formula similar to this:

concat(substring(DateField, 6, 2), "/", substring(DateField, 9, 2), "/", substring(DateField, 1, 4))

Where DateField is the date picker. Hope this helps.

 hi, don. glad for your answer.

i set the fied with the formula, but show the error:

Expect value type: ,

Real value: number

concat(substring(date, 6. -->2<--), "/", substring(date, 9. 2), "/", substring(date, 1. 4))