Skip to Content
0
Former Member
Jun 08, 2009 at 09:31 AM

Date from Calender

26 Views

Hi Experts,

i have a querry

SELECT T0.[DocNum], T0.[CardCode], T0.[CardName], T1.[ItemCode], T1.[Quantity], T1.[Price], T1.[VatSumSy] FROM [dbo].[OINV] T0 INNER JOIN [dbo].[INV1] T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode WHERE T0.[DocDate] = [%] AND T2.[GroupCode] =[%1] AND T1.[LocCode] =[%2] AND T1.[TaxCode] =[%3]

in this when i choose date it display a list of date

but i want to choose date from Calender..

please tell me how i can do this.

Thanks & Regards.

Manoj S