Formatting DateTime Values

[Mark Zak]

I am hoping someone will be able to help me format a datetime value. I'm
working in InfoPath 2007 running on InfoPath Forms Services.

The date value is saving properly however, when I attempt to display it, the
formatting I've chosen is not being followed. I have two expression boxes
bound to the same field with the following properties.
Expression Box 1: Format as "Date and Time", Display the date like this
"3/14/2001", Do not display time".
Expression Box 2: setup the same but using a time format rather than a date
format.

I've also tried choosing a Format as: Date with a selected date format.
Regardless of the settings I've tried the date comes out looking like
"2009-10-20T13:12:21Z". Opening the saved form xml this is the string value
that is recorded. What am I doing wrong?

 

[Anuma (GGK Tech)]

Hi,

You have selected "Date and Time" option in the Format as dropdown for first
Expression box. Instead of the select "Date" for first expression box and
select Time for second Expression box.

 

[Mark Zak]

Yes I have tried that already as mentioned in the bottom of my post.

I got around the issue by storing the date/time in two separate fields as
plain text values. Not the best solution but it works for my situation.