If you want to restrict data up to the current month then use below mention solutions.
1. If you want to consider the whole month then,
Where Date <= Monthend(Today())
2. If you want to load data up to today then,
Where Date <= Today()
* Make sure that Date field format and system format are same.