Date format in subject field of email - InfoPath Dev
in

InfoPath Dev

Having trouble finding a blog or post that answers your question? Check out our Custom Search Page

Date format in subject field of email

Last post 05-09-2012 02:00 PM by Anson Hidajat. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 05-09-2012 12:39 PM

    Date format in subject field of email

    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?

     

  • 05-09-2012 02:00 PM In reply to

    Re: Date format in subject field of email

    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!

    Anson Hidajat
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™

Page 1 of 1 (2 items)
Copyright © 2003-2017 Qdabra Software. All rights reserved.
View our Terms of Use.