Formatting date in a rich text box.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alchemy - 15 Oct 2007 16:52 GMT

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.

Reply to this Message

Clay Fox - 15 Oct 2007 22:25 GMT

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.

Signature

Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

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

> I want to be able to specify a date format in a in a rich text box
> (infopath 2003 sp2).
[quoted text clipped - 7 lines]
>
> I would appreciate any assistance. Thanks in advance.

Reply to this Message

S.Y.M. Wong-A-Ton - 16 Oct 2007 06:55 GMT

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

> I want to be able to specify a date format in a in a rich text box
> (infopath 2003 sp2).
[quoted text clipped - 7 lines]
>
> I would appreciate any assistance. Thanks in advance.

Reply to this Message

Alchemy - 16 Oct 2007 08:30 GMT

On Oct 16, 6:55 am, S.Y.M. Wong-A-Ton
<SYMWongA...@discussions.microsoft.com> wrote:

> 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
[quoted text clipped - 19 lines]
>
> - 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

Reply to this Message