Date format lost on concat

[RyanGarcia]

When I pull the value of a date picker control into a text field via a concat
call, the date value loses the format I selected for that date picker. No
matter what format is chosen, the underlying value of the date is used. So,
for example, it places 2007-02-09 into the text field rather than some other
format like February 9, 2007. Any tips on how to pull the formatted value
over when using concat?

I'm using 2003 SP2.

 

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

Since you cannot set formatting on text fields, you'll have to recreate the
formatting yourself when you pull the value of the date picker into the text
field. This shouldn't be too difficult to do using the concat and substring
functions in a formula.

You can retrieve month names by creating an XML file containing the month
names, create a data connection in your form for this XML file, and then use
the month name values in the secondary data source in your formula that
generates a formatted date for your text field.