Hello All,
I am using InfoPath 2007 to build a web-enabled form that will be published to a SharePoint 2007 Doc Library. I am having some issues with date/time fields. Here is my scenario...
I have a seperate field for each of the following: startDate, startTime, endDate, endTime. I have the date fields formatted as 2001-03-14 and the time fields as 09:46.
I need to find the difference between the date/time an issue started and the date/time the issue was resolved. It could be as little as a few hours or as long as a few days. I tried using this example http://www.bizsupportonline.net/infopath2003/date-time-difference-calculations-vbscript.htm but can not figure out where to find OnAfterChange from the Events dropdown list box on the Data Validation dialog box in InfoPath 2007 (Design).
Any suggestions??? Thank you