Skip to main content
Shannon Hale (Salesforce) 님이 #Validation Rule에 글을 올렸습니다

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 Ghassemieh

and his team!)

@Formulas - Help, Tips and Tricks @The Temple of Shannon Hale
댓글 14개
0/9000