Somehow I cant fix my Date formatting... - InfoPath Dev
in

InfoPath Dev

Somehow I cant fix my Date formatting...

Last post 06-20-2018 12:21 PM by Hilary Stoupa. 5 replies.
Page 1 of 1 (6 items)
Sort Posts: Previous Next
  • 06-20-2018 02:11 AM

    • n0tm3
    • Not Ranked
    • Joined on 06-19-2018
    • Posts 3

    Somehow I cant fix my Date formatting...

    Dear, I have a Sharepoint online list, and a InfoPath (2013) Form, in this list there are several items, whom has a filled in Date (custom, by user). In the form I made connection to the list to read out the dates. So I have a Repeating field. However in the Form it's always listed as DD/MM/YYYYT00:00:00, I want it removed before the T. Now I tried to substring, but the date stays original I tried the eval eval trick, but the source data is still displayed the same I tried with Form Load Rules, and an hidden text field (whom is not empty (I tried checking if the checkbox is empty, didnt work) and than fill the drop box, but I cant get multiple rows, only 1 liners) Formatting where I can set is set to Date and not Date and Time. Tried googling, came to this site, but non of the given answers on other problems seems to work. What I want / Need: Is the T00.. removed from my drop down box. Any Ideas, new tricks I can try? Thanks
  • 06-20-2018 09:29 AM In reply to

    Re: Somehow I cant fix my Date formatting...

    Use substring-before(fieldhere, "T")
    Hilary Stoupa

  • 06-20-2018 09:56 AM In reply to

    • n0tm3
    • Not Ranked
    • Joined on 06-19-2018
    • Posts 3

    Re: Somehow I cant fix my Date formatting...

    Tried that . Doesnt change a thing. Tried it on the load form rule.
  • 06-20-2018 10:27 AM In reply to

    Re: Somehow I cant fix my Date formatting...

    Oh, it's repeating, sorry, I missed that. Are you just displaying this? If so, use a calculated value for the display and use the substring-before formula there. If you attach your template under the Options tab in a reply it will be easier for me to see what's going on.
    Hilary Stoupa

  • 06-20-2018 10:56 AM In reply to

    • n0tm3
    • Not Ranked
    • Joined on 06-19-2018
    • Posts 3

    Re: Somehow I cant fix my Date formatting...

    I can only create calculated formula, whom i cannot use later on in formules (cant select it, its not in items panels) However, i do have a way to get fields filled with that laod form rule. But dont know how to fill a drop down box. I cant get that to work.
  • 06-20-2018 12:21 PM In reply to

    Re: Somehow I cant fix my Date formatting...

    If you want to use the same value in later formulas, could you use the same substring-before formula? Sorry, I'm having a hard time understanding w/out a sample form.
    Hilary Stoupa

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