Field Value Shows Time Stamp - InfoPath Dev
in

InfoPath Dev

Field Value Shows Time Stamp

Last post 01-24-2014 12:29 PM by Angie_Fox. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 01-24-2014 10:19 AM

    • Angie_Fox
    • Not Ranked
      Female
    • Joined on 01-24-2014
    • King George, VA
    • Posts 4

    Field Value Shows Time Stamp

    Help!

    I am trying to populate an ID field with 3 combined fields. 

    FORUM, ACTION TYPE and IDENTIFIED being the 3 fields I need to combine. 

    When it populates the field, it adds the time.  I want to remove it. The calendar control is set to use a date with no time and displays it correctly in the actual IDENTIFIED field but when it populates the ID field, it adds it in.

    Right now the formula looks like this: concat(FORUM, "-", ACTION TYPE, "-", IDENTIFIED).

    It displays like this: SEIPT-BUS-2014-01-21T00:00:00

    I need it to look like this: SEIPT-BUS-2014-01-21

    Thanks in advance for any and all help anyone can provide.

    Regards,

    Angie

     

  • 01-24-2014 10:27 AM In reply to

    Re: Field Value Shows Time Stamp

    You can change the field the calendar control is bound to so that the data type is just Date.

    Or, if for some reason you need the field to be date time:

    concat(FORUM, "-", ACTION TYPE, "-", substring-before(IDENTIFIED, "T"))

    Hilary Stoupa

  • 01-24-2014 12:29 PM In reply to

    • Angie_Fox
    • Not Ranked
      Female
    • Joined on 01-24-2014
    • King George, VA
    • Posts 4

    Re: Field Value Shows Time Stamp

    Thank you so much.  It worked beautifully.  Regards,Angie

     

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