checking if date is last weekday of the month

[amrsherif]

Hi,

I am using a D5 workfile, and would like to know if there is a simple way for obtaining the last weekday of each month (as a string or date).

Thanks

[EViews Gareth]

Code: Select all

smpl if @month<>@month(1) alpha mydate = @datestr(@date, "YYYY-MM-DD") svector lastdates =@uniquevals(mydate)

[amrsherif]

Thanks for this. It works. Can you please briefly explain how the second line works? I thought @date returns the current date.

Also how can i change it to weekdays? Right now, it gives the 31st of Jan 2021.

Thanks again

[EViews Gareth]

Second line just changes @date into the string representation of the date.

If your workfile is D5, there won't be any weekends in it, so it won't report them.

[EViews Gareth]

I should, however, note that the smpl statement will miss the last month in your workfile, so you could modify it with:

Code: Select all

smpl if @month<>@month(1) or @trend=@max(@trend)

[amrsherif]

Great. Thank you