select * from oinv where CreateDate='20160606'
Try the following query.
select Count(DocNum) from <TableName> where DocDate=[%0]
replace the table name here <TableName>
system will ask you to input the date which you will select the current date.
Add a comment