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/122625.aspxTue, 24 Mar 2020 23:38:00 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122625Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122625.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=122625Well, in the browser, the same formula seems to work ok with a time field.... but I suppose if it is just a time, that is going to be confusing for the user? I mean - if you have selected today for the date, and 8 am for the time, then the time -9 hours would be the day before. Is your end goal to display just time? Or date time?https://www.infopathdev.com:443/forums/thread/122624.aspxTue, 24 Mar 2020 23:26:55 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122624Matthew550https://www.infopathdev.com:443/forums/thread/122624.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=122624Hi. We are using the form in the browser.https://www.infopathdev.com:443/forums/thread/122623.aspxTue, 24 Mar 2020 22:52:27 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122623Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122623.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=122623It is so weird. The second I add a time control to my form, the original formula stops working correctly (only subtracts two hours instead of nine) and when I do the same calc on the time field, same thing happens. Are you using this form in the browser or in InfoPath Filler? I'm wondering if it will behave better in the browser....https://www.infopathdev.com:443/forums/thread/122622.aspxTue, 24 Mar 2020 22:34:22 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122622Matthew550https://www.infopathdev.com:443/forums/thread/122622.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=122622Good morning from Japan, Hilary. That's correct. The date is assumed since it's entered previously in the document.https://www.infopathdev.com:443/forums/thread/122615.aspxTue, 24 Mar 2020 15:01:28 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122615Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122615.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=122615So the data type for your field is time only?https://www.infopathdev.com:443/forums/thread/122612.aspxTue, 24 Mar 2020 04:41:26 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122612Matthew550https://www.infopathdev.com:443/forums/thread/122612.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=122612What would the formula be if there was no date. Only time.https://www.infopathdev.com:443/forums/thread/122611.aspxTue, 24 Mar 2020 04:11:44 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122611Matthew550https://www.infopathdev.com:443/forums/thread/122611.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=122611Thank you! I'll give it a try!https://www.infopathdev.com:443/forums/thread/122610.aspxTue, 24 Mar 2020 00:06:46 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122610Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122610.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=122610If you are just subtracting 9 hours, you could use the addSeconds function - use a negative 32400 as the second argument. Right click the link to the attached file, save locally. Right click the saved file and select Design to open in design mode - I've put this calculation in a calculated value control on this sample.https://www.infopathdev.com:443/forums/thread/122609.aspxMon, 23 Mar 2020 23:46:36 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122609Matthew550https://www.infopathdev.com:443/forums/thread/122609.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=122609Hi. I am trying to make a form. The user should type in local time in one field and ZULU or GMC time will populate in a non editable field next to it. The local time is Japan standard time. +9. There is no daylight savings time. For example, if I type in 0900, the Zulu Time field will be 0000Z. We basically take the local time that was entered and minus 9 to populate zulu time. I hope that this is not too confusing. How would I go about doing this?