BusinessOneTraining

Your #1 source for SAP Business One tutorial videos
Business One has updated to 9.0! Videos focusing on new features and changes are coming!
New videos uploaded covering Alerts and A/R!
Business One Training: Now with over 275 videos!
Welcome to the new Business One Training site! Please let us know if you encounter any issues.

Getting the Current Date

Thu, 02/14/2013 - 16:39 -- admin

SAP Business One is built on a SQL Server database and can be queried to get relevant information quickly and easily. In this training video we will look at a special SQL syntax that will allow us to pull the current date into our queries. This can be especially useful in more complex queries that use date analysis to find exceptions.