Re: loading data from last year until the current date
If it has to be the beginning of last year (jan 1st) until today , you can't use a YEAR field in the filter, you have to use a Date field from your source . Assuming your date field is called 'Date' it will be something like this:
WHERE Date >= YearStart( AddYears( Today(), -1 )) and Date <= Today()
This will make sure your date is between "the first date of the year for today's date in the previous year" and "today's date"