Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Mike Yearwood
  Where is Mike Yearwood?
 Toronto
 Canada
 Mike Yearwood
 To: Nandkishor Lande
  Where is Nandkishor Lande?
 Pune
 India
 Nandkishor Lande
 Tags
Subject: RE: Half Month Calculation
Thread ID: 310783 Message ID: 310826 # Views: 30 # Ratings: 0
Version: Visual FoxPro 9 Category: Forms
Date: Saturday, June 25, 2011 6:53:32 PM         
   


> I Have a question
> i have record of one month
> i want to calculate in two part
> 1 to 15 .and. 16 to 30
> i using this code to
>
>
> select * from trans where between(date,dt1,dt2) order by date into cursor x
> &&I want query to all records how to part month in half
> some months have 30 days some months have 31 days and february have 28/29 days how to do it
> 


BETWEEN() is FoxPro, not SQL. The correct SQL syntax is WHERE DATE BETWEEN dt1 AND dt2

Mike Yearwood
Microsoft MVP Visual FoxPro 2008, 2009
We have enough youth. We need a fountain of smart!
There may be many ways to skin a cat, but there are very few right ways to do it.

ENTIRE THREAD

Half Month Calculation Posted by Nandkishor Lande @ 6/24/2011 12:02:10 PM
RE: Half Month Calculation Posted by Anders Altberg @ 6/24/2011 12:30:25 PM
RE: Half Month Calculation Posted by Mike Yearwood @ 6/25/2011 6:53:32 PM