Greater Than Current Month
Posted on 2016-10-10
I have a field: [ValueDate] in mm/dd/yy
What would be the query criteria to exclude records that are in the same month of current date and only show records that are > the month of the current month?
Current Month = October
ValueDate = 10/20/16
ValueDate = 10/1/16
dont show these records because the current month is October.
ValueDate = 11/1/16
==>show this record and any other records that are >current month "mmmm"
Not sure exactly how to say it in words. Please ask if have questions.