InfoPath Dev

Hello, I have found this site very useful.  This is my first time using Microsoft InfoPath 2010. 

I created a form, and I'm using three fields in the subject line of the email it creates. CITY1 and CASE2 are text fields. DATE3 is created with date picker properties, data type is Date (date).

Here is an example of what I want it to look like in someone's inbox:

Fields: CITY1 (DATE3~month - CASE2)
Example: Houston (May - Lonestar)

My problem is editing the date format in the subject line function box.  This is as far as I've been able to figure out on my own:

concat(CITY1, " (", substring-before(substring-after(DATE3, "-"), "-"), " - ", CASE2, ")")

Which makes the subject line look like this:

Subject: Houston (05 - Lonestar)

Is there a way to change the numerical substring date in the function to the MMM format?

Hi there,

Some options you can try:

1) msxsl:format-date() will work, but only in the client.

2) qRules has dat functions which you can use - http://www.qdabra.com/en/products/qRules_new.aspx

3) you can use the month value and create a lookup that will transform a number into a month name

 Hope this helps!