Filter by last ten weeks

Hi Experts

I have a set of data in that I have column with dates in date format (every week Monday) and also week column in YYYYWW format. I want to filter only the last 10 weeks from current day.

Could you please help me on this ?

Thanks in advance

regards,

Rajesh

Sample.xlsx

Datasets

Date Time

Accepted answers

OllieClarke

Hi @RKGV

The following filter should work:

datetimediff(
datetimeadd(datetimetoday(),
(tonumber(datetimeformat(datetimetoday(),'%u'))-1),'day')
,[Date],'day')<=70

Or you can break it out into columns to make it easier

Hope that helps,

Ollie

10weeks.yxmd

All comments

binu_acs

@RKGV can you provide some sample data ?

attached

Hi @RKGV

The following filter should work:

datetimediff(
datetimeadd(datetimetoday(),
(tonumber(datetimeformat(datetimetoday(),'%u'))-1),'day')
,[Date],'day')<=70

Or you can break it out into columns to make it easier

Hope that helps,

Ollie

10weeks.yxmd

RKGV

Thanks everyone for the help

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335