Query: Customers Added Within a Certain Number of Days

Query will prompt the user for a number of days and show the customers that were added within that number of days. Copy and paste into the Query Generator and run.

/*This query will return all customers that have been added to the system */
/*within the number of days selected by the user. Leaving the number of */
/*days blank will return all customers*/
/*Sorted by Days Added Ago Acending */

/*Parameter Definitions*/
/*SELECT FROM [dbo].[ODUN] T0*/
declare @Days as int
/* WHERE */
set @Days = /* T0.EffctAftr */ '[%0]'

/*Main Query Definition*/
SELECT T0.CardCode as 'Customer#', T0.CardName, T0.CreateDate
,datediff (day,T0.CreateDate,GetDate()) as 'Days Ago'
FROM OCRD T0
WHERE T0.CardType='C' and (@days = 0) or (GetDate() - @Days) <= T0.CreateDate
ORDER BY 'Days Ago'
FOR BROWSE

(SAP Business One, SBO)