I have created an app, and I have a view that...

(Peter Westin) #1

I have created an app, and I have a view that I like to show only records within the current week.

how to do that?

peter

(Praveen Seshadri (AppSheet)) #2

Define a slice that filters the records appropriately.

Then use a view over that slice.

(Peter Westin) #3

@praveen Hi, I am a newbie on this, so that is just my problem - I do not now how to create a filter that show only records within the current week.

(Aleksi Alkio) #4

Expression like the above will filter the slice correctly… AND(WEEKNUM(TODAY())=WEEKNUM([Date]),YEAR(TODAY())=YEAR([Date]))

(Peter Westin) #5

@Aleksi_Alkio Super thanks! Translate

(Aleksi Alkio) #6

You’re welcome