Formating Date in a text field that is a string - InfoPath Dev
in

InfoPath Dev

Formating Date in a text field that is a string

Last post 01-10-2012 01:23 PM by traveladic. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 01-10-2012 07:48 AM

    Formating Date in a text field that is a string

    I have a form that some time requires the submition of hardcopies in specific cases and we need to track when we recieve those hardcopies.

    The problem I am having is that when the hardcopies aren't required, that same field need to contain N/A which mean that the field need to be set as a string but when I set it as a string the now() information comes out as "2012-01-10T08:34:54"  and I need it to read as "10-Jan-2012 08:34am".

    any though on how to resolve this?

     Thanks you,

     

  • 01-10-2012 09:49 AM In reply to

    Re: Formating Date in a text field that is a string

    Try pasting this as your formula:

    concat(msxsl:format-date(now(), "dd-MMM-yyyy"), msxsl:format-time(now(), " hh:mmtt"))

    Hope that works for you!

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

  • 01-10-2012 01:23 PM In reply to

    Re: Formating Date in a text field that is a string

    That worked perfectly

    thank you very much

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