Skip to Content
author's profile photo Former Member
Former Member

B1 Query Manager

How can i prompt the user input a date range before

executing the report in B1 query manager?

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 05:21 AM

    Hi Chun,

    Here's how you would do that query:

    SELECT T0.DocNum AS 'Document Number' 
    FROM  [dbo].[OINV] T0  
    WHERE (T0.DocDate >= CONVERT(DATETIME, '[%0]', 112) 
    AND T0.DocDate <= CONVERT(DATETIME, '[%1]', 112) )

    Hope it helps,

    Adele

    Add comment
    10|10000 characters needed characters exceeded