How can I filter out data from the current years quarter but still allow data to be displayed from previous years quarters.
I have been using DatePart("q",[Target Reply Date]) < DatePart("q",Date()) but this won't display previous years data.
Printable View
How can I filter out data from the current years quarter but still allow data to be displayed from previous years quarters.
I have been using DatePart("q",[Target Reply Date]) < DatePart("q",Date()) but this won't display previous years data.
Hi
couldn't you just youse a datetimepicker and allow the user to choose the dates that they want to view?