Weeknum for current year ONLY

Clint_G
Participant II

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.

Solved Solved
0 2 242
1 ACCEPTED SOLUTION

Clint_G
Participant II

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

2 REPLIES 2

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

Clint_G
Participant II

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

Top Labels in this Space