Re: Date format in subject field of email

Anson Hidajat — Wed, 09 May 2012 21:00:43 GMT

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!

Date format in subject field of email

erichardson — Wed, 09 May 2012 19:39:59 GMT

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?

Newbie Questions

Re: Date format in subject field of email

Date format in subject field of email