Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
elie_issa
Creator II
Creator II

How to get first Thursday every month

Dear all,


what is the expression to identify first Thursday every month.

Thanks.

1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

Something like this in script should work:

if(WeekDay(TempDate)='Thu' and Day(TempDate)<='07','FirstMonthThursday','') as FirstMonthThursday

See attached File!

hope this helps

View solution in original post

1 Reply
Frank_Hartmann
Master II
Master II

Something like this in script should work:

if(WeekDay(TempDate)='Thu' and Day(TempDate)<='07','FirstMonthThursday','') as FirstMonthThursday

See attached File!

hope this helps