Page 1 of 1

finding the week containing the first friday of the month

Posted: Tue Nov 26, 2019 8:09 am
by jbonanca
If I am working with a weekly workfile, is there a way to code for a sample that contains all weeks containing the first friday of the month?

Re: finding the week containing the first friday of the month

Posted: Tue Nov 26, 2019 11:33 am
by EViews Matt
Hello,

I believe the following will accomplish what you requested:

Code: Select all

smpl if @datepart(@date + @mod(12 - @datepart(@date, "W"), 7), "DD") <= 7

Re: finding the week containing the first friday of the month

Posted: Tue Nov 26, 2019 12:14 pm
by jbonanca
thank you!