InfoPath Date Display

Q: While working on an InfoPath form the other day, I created a text box for the sole purpose of displaying date/time. When I set the text of the field to Now(), the date appeared as "2005-10-21T13:48:51".

A: To get rid of the "T" in the middle and make the date more readable, I changed the data field type of the text box from Text to Date/Time. The date then appeared as "10/21/2005 1:48:51 PM".

Comments

Eric Richards said…
That's right - InfoPath does some default auto-formatting based on the type of the element.

Note that now() is a date + time and today() is just a date (good for just a date element).

While you could take a text node and force it to format as a date, note that since it's a text node, whatever the user types is going to be put back into the element directly, and then the date formatting code will be confused.

The strange "T" format you see above is known as ISO 8601, which is how dates and times are stored in the XML data for the form.

Cheers,
== Eric.
October 31, 2005 12:30 PM
Post a Comment

Popular posts from this blog

Working with double quotes (") in VB.Net

String manipulation in VB2005 is fairly simple. However, things can get a little tricky with the double quote character. How do you look for it in a string? How can you insert into a string? How do you remove it from a string? These are questions that may lead to confusion if you don't know what you're looking for. Ironically enough, in VB the double quote can also be used as an escape character when searching for it in a string. For example: Dim strTest As String strTest = """123""" 'Displays "123" (double quotes appear in the final result) strTest = """""123""" 'Displays ""123" (double quotes appear in the final result) strTest = "test\""test" 'Displays test\"test strTest = "test""test" 'Displays test"test In cases where you want to insert a double quote character, simply reference it unicode character designation, ch...
Read more

FoxCon 2019

This year I had the privilege of being invited to FoxCon for the 5th time.  FoxCon is a private invite-only conference.  It was started decades ago when FoxPro was one of the products from Microsoft.  Although the product is no longer supported, it is still widely used and loved at many organizations of various sizes.  The FoxCon conference targets FoxPro related topics but the organizers are always open to hear new topics. This year I presented 2 sessions: "SQL Server Security"  and "New Features in SSRS 2017".  Presenting to a technical audience is something I have always enjoyed.  However, it seems much more enjoyable presenting to this group of tech experts. I look forward to attending and possibly presenting again next year.
Read more

Sep '19 Announcements

Listed below are announcements of developer events local and regional to the Cleveland area.  In addtion there are links to job openings and videos of past presentations. Local Events: Oct 1: ONSQL-Cleveland ( https://www.meetup.com/Ohio-North-SQL-Server-User-Group-Cleveland/ ) Oct 16: Hudson Software Craftsmanship Group ( https://www.meetup.com/Hudson-Software-Craftsmanship-Meetup/ ) Oct 24: Cleveland C#/VB.Net User Group ( https://www.meetup.com/Cleveland-C-VB-Net-User-Group/ ) Regional Events: Oct 1: ONSQL-Cleveland ( https://www.meetup.com/Ohio-North-SQL-Server-User-Group-Cleveland/ ) Oct 16: Hudson Software Craftsmanship Group ( https://www.meetup.com/Hudson-Software-Craftsmanship-Meetup/ ) Oct 24: Cleveland C#/VB.Net User Group ( https://www.meetup.com/Cleveland-C-VB-Net-User-Group/ ) Job Openings: TekSystems:  https://www.teksystems.com/it-jobs Inedo:  https://inedo.com/company/career-culture Video: Please subscribe to  https://www.youtube.com/channel/UCU4ffaI...
Read more