selecting records between todays date and a date 29 days from today?

AppSheet AppSheet Q&A
1

i have a field [GregDate] and i would like to select records between todays date and a date 29 days from today. i realise the first parameter is ([GregDate] = TODAY()) but how do i configure the second parameter?

2

Please use AND()

https://support.google.com/appsheet/answer/10107398?hl=en

AND ([GregDate] >= TODAY(), [GregDate] <= TODAY()+29)

1 Like