Skip to Content

Report for date wise marketing data

Hi,

I need to check, How many entries were posted in system. This report should be taken based on the system date not in Doc date. Can anyone have a sql query for this???

Cheers,

Prabakaran R

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jun 29, 2016 at 06:17 AM

    select * from oinv where CreateDate='20160606'

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 29, 2016 at 05:30 AM

    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
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.