Get the current system date using the GetDate() value within your query…
Examples:
SELECT GetDate()
Returns the current date
Use the date for comparisons:
SELECT * FROM OINV WHERE DocDate <= GETDATE()

Thanks to Ed Monk of SBONotes.com