cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
lala
Level VII

How to use JSL to determine whether today is the third Friday of the month?

It seems more complicated.

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Thierry_S
Super User

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).

 

Thierry R. Sornasse

View solution in original post

2 REPLIES 2
jthi
Super User

Re: 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()

-Jarmo
Thierry_S
Super User

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).

 

Thierry R. Sornasse