Newbie Questions

Re: Problems with data formatting

cimerio — Mon, 27 Oct 2014 21:05:48 GMT

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))

Re: Problems with data formatting

donstephen — Tue, 07 Oct 2014 09:42:29 GMT

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.

Problems with data formatting

cimerio — Fri, 03 Oct 2014 16:02:22 GMT

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