How to set date and time with mm/dd/yyyy hh:mm:ss AM/PM format in InfoPath

Problem

To set the date and time with mm/dd/yyyy hh:mm:ss AM/PM format in InfoPath

Solution

Use the below function

concat(substring(today(), 6, 2), “/”, substring(today(), 9, 2), “/”, substring(today(), 1, 4), ” “, substring(“0”, 1, substring(substring-after(now(), “T”), 1, 2) mod 12 + 12 * (substring(substring-after(now(), “T”), 1, 2) mod 12 = 0) < 10), substring(substring-after(now(), “T”), 1, 2) mod 12 + 12 * (substring(substring-after(now(), “T”), 1, 2) mod 12 = 0), substring(substring-after(now(), “T”), 3, 6), ” “, substring(“AP”, 1 + (substring(substring-after(now(), “T”), 1, 2) >= 12), 1), “M”)

That’s it you are done 🙂

Advertisements

About Joseph Velliah
As a SharePoint Developer my professional interests tend to be technical and SharePoint focused. I run a blog at "SP RIDER" where you can expect to read HOW TOs and scenarios that I run into during my day to day job. I hope my posts will give back a little to the community that is helped me.

One Response to How to set date and time with mm/dd/yyyy hh:mm:ss AM/PM format in InfoPath

  1. Prateek Srivastava says:

    Good one Ji 😛

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: