Skip to Content
0

how can i query the Sales Quotation for the Day? thanks

Dec 07, 2016 at 08:14 AM

58

avatar image
Former Member

how can i query the Sales Quotation for the Day? thanks

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Gonzalo Gomez Dec 07, 2016 at 08:33 AM
0

Try this

SELECT T0.[DocNum], T0.[DocDate], T0.[CardCode], T0.[CardName] FROM OQUT T0 WHERE T0.[DocDate] =[%0]

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

thanks.. But for the day..

Select docnum, docdate, cardcode, cardname from oqut where createdate = convert(date,getdate())

0