cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
lala
lala
Level VIII

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

Aug 24, 2023 12:11 AM (591 views)

It seems more complicated.

Thanks!

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
Thierry_S
Super User Thierry_S
Super User
Solution

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

Aug 24, 2023 12:54 AM (583 views)  |  Posted in reply to message from lala 08-24-2023

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 jthi
Super User

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

Aug 24, 2023 12:45 AM (587 views)  |  Posted in reply to message from lala 08-24-2023

I think you can use combination of Day Of Week() and Nth Day Of Week in the Month()

-Jarmo
Thierry_S
Super User Thierry_S
Super User
Solution

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

Aug 24, 2023 12:54 AM (584 views)  |  Posted in reply to message from lala 08-24-2023

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