CODE EXAMPLE FOR SQL

sql date range

Use DateDiff((year | day | month) , dateold,(datenew | sysdatetime()));