Hi,
I have an InfoPath 2007 form, which is used as a checklist for users throughout the day. The logic is as follows
User clicks a button control.
Complete (Yes / No) field is updated to Yes. (this field is hidden)
Thisn update then also updates a Time Value in another field with the formula: substring-after(now(), "T")
Meaning when a user clicks a button, it marks a task as complete and sets the current time. If the user clicks the button again, it clears all of this data.
Problem is, when I actually submit the form; the time values are all updated with the submission time, not the time the button was clicked.
Any ideas? Thanks...Rob