Re: Expression box and concat() date formatting

Kalyan Gaddam — Mon, 03 Jul 2006 02:37:30 GMT

Hello,

Select Date type from the data type in the Datepicker Properties instead of Date and time and then trying to not show the time from the format button.
Also read the links below
http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=2640
http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=995

Expression box and concat() date formatting

CaptainAi — Mon, 03 Jul 2006 01:01:51 GMT

Hi InfoPath experts,

Any help with this issue would be much appreciated.

I am using an expression box with a concat() function that calls 5 fields with the last one being a date field (date of birth) - this is for the subject line of a letter that is auto-generated in a view of the form. I have spaced and added static content within the function. All of the data displays 100% correct- even the date, except that the date format diplays like this: "1973-11-23T00:00:00".

The field it calls (date of birth) is a properly formatted field (dd/mm/yyyy)with "do not display time" selected. The fields' value is stored in the database as short time date field, again with no time attribute. Why would the format become yyyy-mm-dd and have a time format added on to it just by calling the field in an expression box?

Obviously I could just call the date of birth seperately in a date picker (and format it - next to the other data in the expression box) instead of adding it into the concat() expression in the expression box but I find that aesthetically, using an expression box with concat()is much easier as it auto-arranges the called data (i.e. you don't get big gaps or partial data when data lengths change from record to record). So if there is anyway of formatting the called date within the concat() expression in the expression box I would love to know.

Thanks.

Newbie Questions

Re: Expression box and concat() date formatting

Expression box and concat() date formatting