キャンセル
次の結果を表示 
表示  限定  | 次の代わりに検索 
もしかして: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
言語を選択 翻訳バーを非表示
lala
Level IX

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

It seems more complicated.

Thanks!

1 件の受理された解決策

受理された解決策
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

元の投稿で解決策を見る

2件の返信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

おすすめの記事