Search - InfoPath Dev Sign in | Join | Help InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads Search More Search Options Page 1 of 1 (6 items) Re: now() function question [quote user="Hilary Stoupa"] I'd guess you have something else setting the field? Maybe check it out in the rule inspector.[/quote]Hi Hilary, Thanks so much Hilary - got it all working! Very helpful advice on here - thanks :) Posted to Controls (Forum) by mattderby on 06-03-2015 Re: now() function question [quote user="Hilary Stoupa"] NaN = Not a Number. You are using number(substring(now(), 12, 5). The time has a ":" in it - thus is not a number. Try substring(now(),12,5) instead. If you want underscores instead: concat(number(substring(now(), 9, 2)), "_", number(substring(now(), 6, 2)), "_", ... Posted to Controls (Forum) by mattderby on 06-02-2015 Re: now() function question [quote user="Hilary Stoupa"]I'm confused as to what you are trying to do and what your desired result is - can you tell me what you want the outcome to look like (your formula has "/" in it, and there are none in your output, so I'm sort of baffled) and attach a sample form under the options ... Posted to Controls (Forum) by mattderby on 06-02-2015 Data Connections - Emails Hi guys, A question if I may about data connections - email submits Is it possible to add fields to the Introduction at all? I've seen this link (4th post down) but I don't understand it at all - where I am inserting that code? Thanks for any help :) Posted to General (Forum) by mattderby on 05-29-2015 Re: now() function question Thanks Hilary but it still doesn't work? This is the formula I have: concat(number(substring(now(), 9, 2)), "/", number(substring(now(), 6, 2)), "/", number(substring(now(), 3, 2)), "/", number(substring(now(), 12, 5)), "-", Username) It comes up like: 28_5_15_NaN-username So I still can't get ... Posted to Controls (Forum) by mattderby on 05-28-2015 Re: now() function question Sorry to drag up a very old thread - but Scott's post was very helpful. However I can't seem to get it work for the time. I though this would work: concat(number(substring(now(), 10, 4))) Which would show the hour and the minutes (but not seconds) but it doesn't. Anyone can help?? Thanks :) Posted to Controls (Forum) by mattderby on 05-22-2015 Page 1 of 1 (6 items) Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.