I need an expression that will return month-to-date info on sales.changing the year manually is not a problem. I would like to not have to change the month. my year to date looks like this:
Between #1/1/00# And Date()-1
this is an expression fromthe criteria field for an ODBC query to a Unix system. the field name is INV_DATE.
