Formatting date in a rich text box.

[Alchemy]

I want to be able to specify a date format in a in a rich text box
(infopath 2003 sp2).

I have concat text and dates (found in the form) in a rich text field.
Is there a way of applying date format dd/mm/yyyy to a rich text box?
Currently all the date are coming out as yyyy-mm-dd.

"...letter of acceptance and instruction in relation to your tender
dated 2007-10-18 for the execution and completion....."

I would appreciate any assistance. Thanks in advance.

 

[Clay Fox]

One trick is to add an additional field which defaults to your date field but
has the formatting you want and then concatenate its value instead of the
original.

I believe this will allow you to solve your situation.

--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

 

[S.Y.M. Wong-A-Ton]

If you're already using the concat() function, you can combine concat() with
substring() to create the format you desire for dates. Use something like

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

for each date field.

 

[Alchemy]

If you're already using the concat() function, you can combine concat() with
substring() to create the format you desire for dates. Use something like

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

for each date field.
---
S.Y.M. Wong-A-Ton








- Show quoted text -

Thank-you very much!

I successfully used S.Y.M. Wong-A-Ton substring formula and it worked
exactly as required! I'm really very grateful. I had tried Clay's
workaround however run into problems. Gentlemen, I take my hat off to
both of you for your assistance.

With regards,

Alchemy