SAP Business One 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()

Thanks to Ed Monk of SBONotes.com

2019-01-16T11:44:20+00:00 February 11th, 2009|SAP Business One|Comments Off on SAP Business One Need the Current Date to Use Within Your Query?