Pass 10 weeks from existing weeknum()

[desmond_lee]

Hi Guys

Is there a way to compute pass 10 week from now? The t=column is [TIMESTAMP] and the data to filter is [Employee ID]

[Suvrutt_Gurjar · Accepted solution]

Thank you.

Please try a slice filter of 

AND(  DATE([INSPECT TIMESTAMP]) >=EOWEEK( TODAY()) -75

             DATE([INSPECT TIMESTAMP]) <=EOWEEK( TODAY()) -71

            )

for Monday to Friday dates 10 weeks back from current week.

Please try a slice filter of 

AND(  DATE([INSPECT TIMESTAMP]) >=EOWEEK( TODAY()) -76

             DATE([INSPECT TIMESTAMP]) <=EOWEEK( TODAY()) -70

            )

for Sunday to Saturday dates 10 weeks back from current week.

As per AppSheet standard, the week is considered from Sunday to Saturday. 

[desmond_lee · Accepted solution]

Thank very but it work on this AND(DATE([INSPECT TIMESTAMP]) >=EOWEEK( TODAY()) -76,[INSPECT TIMESTAMP] <= NOW()). Mind to tell me what is the -70 and -76 mean?

This is the orginal suggested by appsheet AI itself

AND(TOTALHOURS(NOW() - [INSPECT TIMESTAMP])/24 <= 70, [INSPECT TIMESTAMP] <= NOW())