https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/125007.aspxSun, 31 Jul 2022 07:20:15 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125007rticehurst0https://www.infopathdev.com:443/forums/thread/125007.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=125007Thanks so much Hilary, worked a treat.https://www.infopathdev.com:443/forums/thread/125006.aspxFri, 29 Jul 2022 16:12:23 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125006Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/125006.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=125006Datetime in XML is yyyy-dd-MMTHH:mm:ss. It can be confusing, because the controls on the form may be formatting the date time, but that doesn&#39;t change the underlying value. The today function will return today&#39;s date, so you could just use something like this: concat(today(), &quot;T07:30:00&quot;)https://www.infopathdev.com:443/forums/thread/125005.aspxFri, 29 Jul 2022 09:00:56 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125005rticehurst0https://www.infopathdev.com:443/forums/thread/125005.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=125005<p>&nbsp;I am rebuilding some old Sharepoint Designer forms with InfoPath.&nbsp; The forms support a sharepoint list that we use in the pharmacy for recording the prescription orders received from the hospital wards (in New Zealand).&nbsp; Each morning the staff arrive and there will be a heap of prescriptions received overnight and staff need to enter them in the list with a date and time received of today&#39;s date and a specific time.&nbsp; The field is defaulted to Now() and i have a button (javescript) on the old form that the staff simply click and it populates today&#39;s date and the time of 07:30.</p><p>I&#39;ve created the form and added some buttons but have become stuck on the formula that i require.&nbsp; I have seen various posts&nbsp; on this forum related to this but none that cover this specific issue.&nbsp; The secondary challenge is that InfoPath creates the date time control formats as two fields - one with the date (date picker) and the second with the time (text).&nbsp; Existing posts that describe a formula for a button to complete the date (eg add 7 days) put the same value in both fields but that then fails the validation step.</p><p>I can;t post images but when i open the form the two fields correctly display now() with the date in the first field and the time in the second field.&nbsp; I have a button for reseting the date and time to now() and that works properly - date in one field and time in the other.&nbsp; My second button is labelled &#39;overnight&#39; and has the following code to the set the field value<i>:</i></p><p><i>concat(number(substring(now(), 9, 2)), &quot;/&quot;, number(substring(now(), 6, 2)), &quot;/&quot;, number(substring(now(), 1, 4)), &quot; 7:30:00&quot;)</i></p><p>I know my code isn;t right - hence this post, but when i hit the button it pops the same value in both fields (29/07/2022 7:30:00) whereas i just need the specified time of 07:30:00 in the second field.&nbsp; Any ideas?</p><p>Thanks in advance<br /></p>