From the course: SAP Business One: Reporting and Customization

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Use SQL functions

Use SQL functions - SAP ERP Tutorial

From the course: SAP Business One: Reporting and Customization

Start my 1-month free trial

Use SQL functions

“

- [Instructor] You've used parameters to run this report, and I showed you the quick way to get the current date. You might want the due date to be two weeks the future. You can do that with sequel functions. Change the date selections parameter to the following. We're going to get rid of all of this here. It's in the gray, as you can tell, cause we reran this. I'm going to, first of all, hit the pencil to edit it, and then I'm going to get rid of all of this here. I'm going to change that to T0.DueDate, and that's going to be less than or equal to. Then, I'm going to put a function GETDATE. This function, you can tell it's a function, cause it's got parentheses after the keyword. This one happens to have nothing special about it. It just gets the current date. If you run again, you now only get one question. I'm going to pick planned, and there's all our planned ones. These are all the things with a due…

Contents