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.

Date and string functions

Date and string functions - SAP ERP Tutorial

From the course: SAP Business One: Reporting and Customization

Start my 1-month free trial

Date and string functions

“

- [Instructor] With our new tools, let's get back into Sequel. There's a lot of functions in Sequel. Let's look at some more very useful ones. Now, we commented out the WHERE a few videos ago. And I showed you how to change comments to deal with the parameter issue, so that it doesn't show parameters. Now our requirements are going to need something different than this version of WHERE. I need Open Orders, and I need 90 days and back Due Dates. To get all this working, you'll find a few more functions helpful here. So I'm going to copy this comment in line, then press return, and I'm going to paste it right back in. And I'm going to clean it up a little bit, I'm going to change out the status, get rid of that. So we just have the Due Date, the Due Date now we're going to have a different Due Date. So what we want is anything less than 90 days from today. So, what we need to do is change right here, that to…

Contents