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?
 Mike Yearwood
 To: Nandkishor Lande
  Where is Nandkishor Lande?
 Nandkishor Lande
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.


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