In need of a formula that allows for classifying a text formula field when a task/activity's created date is equal to last modified date, then it will be classified as NEW. If the task/activity's last modified date is greater than the created date, then it will be classified as UPDATED.
Please help! Thank you.
10 Antworten
Interesting. Did you try creating a new Task record and then testing? To accommodate the lag in record creation, can you try the following?
IF( (LastModifiedDate - CreatedDate) * 24 * 60 < 0.25 , "NEW", "UPDATED")
Vinay: ISNEW() cannot be used in formula fields.
