Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: John Hayna
  Where is John Hayna?
 
 Philippines
 John Hayna
 To: mk sharma
  Where is mk sharma?
 mumbai
 India
 mk sharma
 Tags
Subject: RE: Expiry List Report
Thread ID: 331303 Message ID: 331315 # Views: 28 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Wednesday, December 28, 2011 8:52:08 PM         
   


You got it right MK, yes to return the products to the supplier those that are near to expire. Thanks.

> > Thanks MK, I will try this.
> >
>
> please try this SQLEXEC()
>
>
> local ldtoday, ldmaxdate
> ldtoday=date()
> ldmaxdate=ldtoday+180
> 
> SQLEXEC(m.lnConn, 'select * from yourtable where expiry Between ?m.ldtoday And ?m.ldmaxdate', 'junkexpiry')
> 
> *** OR
> SQLEXEC(m.lnConn, 'select * from yourtable where expiry>=?m.ldtoday And expiry<=?m.ldmaxdate', 'junkexpiry')
> 
> 
> BROWSE
> 

>
> i think you want only Future expiry products. (From Today to 6 Months)
> i think you want this report for submit a claim to Manufacturer or distributor.(or to return the near future expiry products to the Supplier)
>
>
> Warm Regards,
> mk.

ENTIRE THREAD

Expiry List Report Posted by John Hayna @ 12/28/2011 6:53:36 PM
RE: Expiry List Report Posted by mk sharma @ 12/28/2011 7:14:36 PM
RE: Expiry List Report Posted by Stefan Wuebbe @ 12/28/2011 7:40:19 PM
RE: Expiry List Report Posted by mk sharma @ 12/28/2011 7:59:07 PM
RE: Expiry List Report Posted by John Hayna @ 12/28/2011 7:50:05 PM
RE: Expiry List Report Posted by mk sharma @ 12/28/2011 8:07:52 PM
RE: Expiry List Report Posted by John Hayna @ 12/28/2011 8:52:08 PM
RE: Expiry List Report Posted by mk sharma @ 12/28/2011 8:55:39 PM
RE: Expiry List Report Posted by Stefan Wuebbe @ 12/28/2011 7:17:50 PM
RE: Expiry List Report Posted by John Hayna @ 12/28/2011 7:51:33 PM
RE: Expiry List Report Posted by John Hayna @ 12/28/2011 8:44:15 PM
RE: Expiry List Report Posted by Stefan Wuebbe @ 12/28/2011 9:17:21 PM
RE: Expiry List Report Posted by tushar @ 12/29/2011 5:35:37 AM