Need the Current Date to Use Within Your Query?

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()

Login or register to post comments