课程: SAP Business One: Reporting and Customization

今天就学习课程吧！

今天就开通帐号，24,700 门业界名师课程任您挑！

Use SQL functions

Use SQL functions - SAP ERP教程

课程: SAP Business One: Reporting and Customization

开始一个月试用 购买团队方案

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…

内容