How to use JSL to determine whether today is the third Friday of the month?It seems more complicated.
Thanks!
Automation and ScriptingRe: How to use JSL to determine whether today is the third Friday of the month?I think you can use combination of Day Of Week() and Nth Day Of Week in the Month()
Re: How to use JSL to determine whether today is the third Friday of the month?Hi,
Would this simple formula meet your needs?
If( Nth Day Of Week in the Month( :DATE ) == 3 & Day Of Week( :DATE ) == 6,
1,
0
)
Based on my calendar, it works on any DATE input. If you specifically need to check for the current date, replace ":DATE" with "Today ()" (without quotes).
