<div>
That is the raw date format.<br />
<br />
The only way I know is to use substring commands to get the year, dat and month seperated and then concat them back together.<br />
<br />
substring-after(substring-<wbr />after(date<wbr />, &quot;-&quot;), &quot;-&quot;) would get the day field.
</div>


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.

<div>
Ok thanks, that gave me the day, when I substituted &quot;Date&quot; with &quot;Field6&quot; (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. <br />
<br />
Thanks for your help. 
</div>


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.

<div>
Awesome, that works well! Thanks a lot
</div>


<div>
<div class="content wysiwyg-content">
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 &quot;2010-4-26&quot;. I would prefer the format &quot;26/4/2010&quot; but cannot see if it is possible to change that. 
</div>
</div>


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. 

Date format in subject field of email

Microsoft InfoPath is a software application for designing, distributing, filling and submitting electronic forms containing structured data. The product features a WYSIWYG form designer in which the various controls (e.g. textbox, radio button, checkbox) are bound to data, represented separately as a hierarchical tree view of folders and data fields. All the data stored in InfoPath forms are stored in an XML format. Secondary data sources can be built into the form or they can be accessed through an external data connection to SharePoint or a Web service.