<div>
dFromDate = DATE()<br />
dToDate = DATE()+5<br />
SELECT * FROM table WHERE date &gt;= dFromDate and date &lt;= dToDate
</div>


dFromDate = DATE()
dToDate = DATE()+5
SELECT * FROM table WHERE date >= dFromDate and date <= dToDate

<div>
Thanks, CaptainCyril.<br />
However we do not work at weekends, or bank holidays etc so selecting the next 5 days will, after tuesday, return saturday/sunday &nbsp;which are empty.<br />
I am afraid my people need to see all 5 days, even allowing for gaps. Since the actual working dates are fixed as part of the originating database, then the first 5 rows will always be the next 5 days, if you get my drift!<br />
Thanks again.
</div>


Thanks, CaptainCyril.
However we do not work at weekends, or bank holidays etc so selecting the next 5 days will, after tuesday, return saturday/sunday  which are empty.
I am afraid my people need to see all 5 days, even allowing for gaps. Since the actual working dates are fixed as part of the originating database, then the first 5 rows will always be the next 5 days, if you get my drift!
Thanks again.

<div>
<div class="content wysiwyg-content">
Hi:<br />
A smallish question:<br />
I have a table of planned production, one row for each date from today.<br />
I want to extract (either as query or export) only the first 5 rows; being the next 5 working days.<br />
Is there a facility to do this in vfp, please?<br />
I was thinking about a loop that flagged the first 5 rows, then select those flagged- but is there another way?<br />
Thanks!
</div>
</div>


Hi:
A smallish question:
I have a table of planned production, one row for each date from today.
I want to extract (either as query or export) only the first 5 rows; being the next 5 working days.
Is there a facility to do this in vfp, please?
I was thinking about a loop that flagged the first 5 rows, then select those flagged- but is there another way?
Thanks!

SELECT SPECIFIC NUMBER OF RECORDS VFP

Visual FoxPro (VFP), and its predecessor FoxPro, is a data-centric, object-oriented, procedural, database programming language and IDE from Microsoft last released in 2007 that still has some active use due to its low cost of deployment and fairly rapid development. In 2008, Microsoft released a set of add-ons for VFP's xBase components to allow interoperability with various Microsoft technologies. It allows data processing against its native file-based data tables or database servers such as SQL Server.