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

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

lala — Thu, 24 Aug 2023 04:11:26 GMT

It seems more complicated.

Thanks!

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

jthi — Thu, 24 Aug 2023 04:45:43 GMT

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?

Thierry_S — Thu, 24 Aug 2023 04:54:15 GMT

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