Is there a way we can check if a certain date field (say My_date
) falls on the third Tuesday of any given month?
We want to prevent users from selecting certain dates throughout the year.
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this communityIs there a way we can check if a certain date field (say My_date
) falls on the third Tuesday of any given month?
We want to prevent users from selecting certain dates throughout the year.
AND(
DAY( My_date ) > 14, /* 14th day of month */
DAY( My_date ) < 22, /* 22nd day of month */
WEEKDAY( My_date ) = 3 /* Tuesday */
)