[development-axapta] Re: Select date range

[henriktonnesen]

This might help 

   QueryBuildDataSource    qbds;
   QueryBuildRange         qbr;
   Query                   q;
   QueryRun                qr;
   q       = new Query();
   qbds    = q.addDataSource(tablenum(InventTrans));
   qbr     = qbds.addRange(fieldnum(InventTrans,DateFinancial));
   qbr.value('16-09-2003..18-09-2003,02-09-2003..05-09-2003,12-08-
2003');
   info(qbds.toString());
The qbds.toString() returns a "sql-statement" with
(DateFinancial>=16-09-2003 AND DateFinancial<=18-09-2003 OR 
DateFinancial>=02-09-2003 AND DateFinancial<=05-09-2003 OR 
DateFinancial = 12-08-2003) which need a little parsing.

Good luck

--- In [EMAIL PROTECTED], "Steeve Gilbert" 
<[EMAIL PROTECTED]> wrote:
Hi all!

  Let's say a date range entered by the user like
"2003-10-13..2003-10-17, 2003-09-16" or anything that is a valid 
date
range.  I want to be able to get a list of all the dates that are
included by this range.
Some weird way would be to select a table that contains all 
possible
dates and restrain it with this range, then I would get a list of 
all
the date included by this range.  But I don't think that such a 
table
exist.

Do you know a way to achieve this?

Steeve...


Yahoo! Groups Sponsor	 
ADVERTISEMENT
click here	
	

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.