I need to set the current date on a field based on the selection of a value of another field.
I have tried using a calculated date field based on several other forum answers that I've found. However, the date will change to the current date no matter what parameters I give the calculated field.
For example, I have an option set with values of "Approved" and "Rejected." I want to set the Approval Date field to today's date as soon as the user selects "Approved" from the option set. However, I do NOT want that date to change in the future so I can preserve the date when the record was "Approved."
I have tried to use a calculated date field with the following condition/action:
- If [approval field] = approved
- set [approval date] = NOW()
Alternately:
- If [approval field] = approved
- set [approval date] = modifiedon()
Both of these configurations, however, will set the date to the current date and time whenever I open the record.
I have tried the workflow approach but obviously can't dynamically set the date to "today."
I also can use jscript if necessary but would rather not as I'm in a time crunch.
