I sure need some help with this one. I thought this would be simple....
Essentially, I built a custom record to track pieces of work, worked. I have a Time Started field that basically grabs the current date AND time (I need the seconds as well), this is working. I then have a Time Closed field, I need this field to grab the current date and time (including seconds, e.g. 12:59:36PM) when the custom field "Status" is set to closed. I would like it to happen after record submit. The closest I could get so far was to build a workflow that has a Set Value action. In the Set Value action, I put "current_date" in the formula field for the field I want to set the value of. While this does work, the time is 4 hours off what it should be... If anyone could help with this I would be GREATLY appreciative. Thanks in advance for any info at all!
Best Regards,
Steven