Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: tushar Kanvinde
  Where is tushar Kanvinde?
 Kolhapur, Maharastra
 India
 tushar Kanvinde
 To: John Hayna
  Where is John Hayna?
 
 Philippines
 John Hayna
 Tags
Subject: RE: Expiry List Report
Thread ID: 331303 Message ID: 331346 # Views: 27 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Thursday, December 29, 2011 5:35:37 AM         
   


> It works great Stefan. Thanks a lot.
>
> >
> >
> > You can probably use GoMonth() inside VFP and a parameterized query string, something like the following pseudo-code example, where the details would depend on whether you are using CursorAdaters, remote Views or SPT on the client side:
> >
> >
> > Local ...
> > ltSixMonthsLater = GOMONTH(DATETIME(),6)
> > lnSuccess = SQLEXEC(..., "Select ... From yourTable Where expiry <= ?m.ltSixMonthsLater", ...)
> > 

> >
> >
> >
> >
> > hth
> > -Stefan

You may also want to check if the stock of that item is 0. Unless the table has only items with stock.

Regards
Tushar

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