https://www.infopathdev.com:443/forums/46.aspx For questions concerning issues in the integration of SharePoint and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/119303.aspxWed, 20 Jun 2018 19:21:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119303Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/119303.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=119303If 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.https://www.infopathdev.com:443/forums/thread/119302.aspxWed, 20 Jun 2018 17:56:05 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119302n0tm30https://www.infopathdev.com:443/forums/thread/119302.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=119302I 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.https://www.infopathdev.com:443/forums/thread/119301.aspxWed, 20 Jun 2018 17:27:41 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119301Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/119301.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=119301Oh, 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.https://www.infopathdev.com:443/forums/thread/119300.aspxWed, 20 Jun 2018 16:56:40 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119300n0tm30https://www.infopathdev.com:443/forums/thread/119300.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=119300Tried that . Doesnt change a thing. Tried it on the load form rule.https://www.infopathdev.com:443/forums/thread/119299.aspxWed, 20 Jun 2018 16:29:52 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119299Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/119299.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=119299Use substring-before(fieldhere, "T")https://www.infopathdev.com:443/forums/thread/119296.aspxWed, 20 Jun 2018 09:11:08 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:119296n0tm30https://www.infopathdev.com:443/forums/thread/119296.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=119296Dear, 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