Hi Guys
I need an expression to return in a slice dates between TODAY and 30 Days time?
In access I would do something like:
=>Date() and <=Date()+30
Can someone assist
TIA
Edit:
Is this correct?
AND([MOT Expires] >= TODAY(), [MOT Expires] <= TODAY()+30)
Is [MOT Expires] a Date column or Date/Time?
Its a Date column.
Cheers
Looks perfect:)
Thank you, it seems to be doing the trick.
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |