Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Nandkishor Lande
  Where is Nandkishor Lande?
 Nandkishor Lande
Subject: Half Month Calculation
Thread ID: 310784 Message ID: 310784 # Views: 25 # Ratings: 0
Version: Visual FoxPro 9 Category: Forms
Date: Friday, June 24, 2011 12:02:14 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


Half Month Calculation Posted by Nandkishor Lande @ 6/24/2011 12:02:14 PM
RE: Half Month Calculation Posted by Stefan Wuebbe @ 6/24/2011 12:20:49 PM