Merging from XML but my date is so broken!!!

[roninl]

I have data from an XML file.  It merges with my PDF template as read only.  The date from the XML is formatted as follows:

YYYY-MM-DD-06:00

The "extra" on the end is a time zone code.  It is stored in the database like that.

On my form I have a read only that displays the date above - problem is it looks like that, too!

Anyway for me to format that?  I've set the field to date type and set input and formats - nothing works.  I'm using 8.0.  I tried to "script" something but I guess I'm not smart enough to know where those scripts would reside nor what they should say because I've spent days and none of my attempts have given me anything but the above output.

Thank you!

[_Bruce_Robertson · Accepted solution]

Hi ronini,

You should be able to use the following data pattern on your date field;

date{YYYY-MM-DD??????}

On input the data must match the YYYY-MM-DD part but the characters matched by questions marks will be ignored.

On output you would end up with spaces where the question marks.

Bruce

[roninl]

Bruce?

How did you know that?  I thought I read everything out there but I was still so stupid!  This was the perfect fix and I'm so very happy you took time to respond to me!

Thank you so much!  I sincerely apreciate the support!  My entire month (okay-project) is 100% better because of this little bit of time you took for me!

roninl

[_Bruce_Robertson]

Hi roninl,

I'm glad I could help and understand all too well the problems of finding relevant information.  The picture clause symbols are discribed on page 1067 !! of the 1446 page document XFA Spec 3.0 at http://partners.adobe.com/public/developer/xml/index_arch.html#xfa_30

Happy reading.

Bruce

[Jono_Moore]

More compact version here:

http://partners.adobe.com/public/developer/en/xml/picture_clause_2.0.pdf

[soo123w]

Hi Bruce,

I am having the same problem that Roninl  described.  I  am not sure if I missed anything.  I've tried to use the date pattern date{YYYY-MM-DD??????} that you suggested for the display pattern, but the date field still displaying something like: 2011-04-13-06:00 with the time zone.

BTW, I am using Adobe LiveCycle Designer ES2 Version 9.0.0.2.20100902.2.720808.

Thanks,

soo123w

[soo123w]

I know where my problem was and I got it fixed.  Thanks!

[roninl]

soo123w:

Where did you find the problem and what was the solution?  I'm revising this because I now have a new problem and thought this might help.  Perhaps your answer would solve my problem.

Thank you!

Roni