Ignore null when pulling data?

Hello guys.
I’m using the jdbc and My-Sql… when polling data let’s say one month back, the result isn’t correct if there only is data from last week… isn’t it possible to make it ignore null or empty data? I wanna use the SumSince command, to see data for this year, but can’t be done correct?