I’m trying to modify a BAQ to display YTD results. I’d like the InvoiceDate criteria to be >= 1/1/{this year}.
I can’t, however, figure out how to create the specific expression in the BAQ. Do I use the convert(date,…) function? Is there another way to easily set InvoiceDate >= 1/1/2019?
Thank you.
It looks like I can also just set FiscalYear = BAQ Year Constant.
That seems to get the right data. However, I’d still be interested in getting a YTD result when I don’t have Fiscal Year available.
Depending where you’re doing it, YEAR(InvoiceDate) = YEAR(GETDATE()) can work. Or InvoiceDate >= DATEFROMPARTS(YEAR(GETDATE()),1,1).