Solved: Re: Weeknum for current year ONLY

Clint_G · 08-06-2021 05:16 PM

Attempting to report a slice from a table for entries with date for the current week. This works well but I have noticed that the slice is now pulling in previous years entries for current week number also. This means items from 8/2/2021 and 8/2/2020 are returned undesirably in this case.

I am using:

WEEKNUM([Date entered]) = WEEKNUM(TODAY()-1)

Assistance appreciated, thanks.

Clint_G

Well it’s kind of annoying that the answer are not spoonfed to me but it’s satisfying figuring it out. Thanks for the resources you linked. I will post my solution here for others.

This is a solution for WEEKLY results:
and(WEEKNUM([Date entered]) = WEEKNUM(TODAY()-1),year([date entered])=year(today()))

This is a solution for MONTHLY result:
and(MONTH([Date])=MONTH(EOMONTH(TODAY(), - 1)),year([date])=year(today()))

View solution in original post

Marc_Dillon

Use AND(), and compare against the year as well.

Clint_G

Well it’s kind of annoying that the answer are not spoonfed to me but it’s satisfying figuring it out. Thanks for the resources you linked. I will post my solution here for others.

This is a solution for WEEKLY results:
and(WEEKNUM([Date entered]) = WEEKNUM(TODAY()-1),year([date entered])=year(today()))

This is a solution for MONTHLY result:
and(MONTH([Date])=MONTH(EOMONTH(TODAY(), - 1)),year([date])=year(today()))