Articlescreatedbetweendates
Report ArticlesCreatedBetweenDates
- Filename:
- Title: List of articles created between :FromDate and :ToDate
- Sample: Unit63
Synopsis
Print a list of articles, created between 2 dates.
SQL
SELECT
a.name, a.weight, a.vol,
isnull(right(min(right(b.location, 1)+' '+b.location),15), '') as location
FROM
article a
LEFT JOIN stoctotal b ON
(A.NAME=b.ARTCODE)
and (b.qtyin - isnull(b.qtyout,0))> 0
WHERE
(FILLDATE Between :FromDate and :ToDate)
group by
a.name, a.weight, a.vol
order by
a.NAME asc
Parameters
- FromDate Start of create period.
- ToDate Start of create period.