Did you know that effective Summer '14, you can access activity dates in formulas? For example, if you've ever wanted to ensure that users can't backdate a task due date more than three days, you could write the following validation rule:
ActivityDate < TODAY() - 3
You can also access the event start date/time, but there's a trick: if it's an all-day event, you use the ActivityDate field, but if it's got a date and time, you need the ActivityDateTime field. So a similar validation rule on events looks like this:
IF(
IsAllDayEvent,
ActivityDate < TODAY() - 3,
DATEVALUE(ActivityDateTime) < TODAY() - 3
)
(I get no credit for this one - it was all
@Kayvaan Ghassemiehand his team!)
@Formulas - Help, Tips and Tricks @The Temple of Shannon Hale14 commentaires