Date format in subject field of email

I have created a form and two of the fields in the form use the 'Date Picker' control. I got those dates to come through to the Subject field of the email that is generated when the user clicks 'Submit', but the date is coming through in the format "2010-4-26". I would prefer the format "26/4/2010" but cannot see if it is possible to change that.
LVL 1
HarknessHenryAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Clay FoxDirector of Business IntegrationCommented:
That is the raw date format.

The only way I know is to use substring commands to get the year, dat and month seperated and then concat them back together.

substring-after(substring-after(date, "-"), "-") would get the day field.
0
HarknessHenryAuthor Commented:
Ok thanks, that gave me the day, when I substituted "Date" with "Field6" (the field that contains my date picker control). Sorry, I don't know what part of that formula you gave me means that I got the day as opposed to the month or year, so can you tell me how I now get the month and year? I have already used the concat command to allow me to put some text as well as a field in my Subject field so I am reasonably familiar with how that command works, but have no idea how I would use it to return my day, month and year.

Thanks for your help.
0
Clay FoxDirector of Business IntegrationCommented:
substring-after(substring-after(date, "-"), "-"), "/", substring-before(substring-after(date, "-"), "-"), " /", substring-before(date, "-")

This would give you day / month / year
You just have to use substrings to get the characters you need then recombine them.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
HarknessHenryAuthor Commented:
Awesome, that works well! Thanks a lot
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
InfoPath

From novice to tech pro — start learning today.