Date range for previous 7 days

ajit

Hi,
Does anyone know how to set date range where by i want to access records from the current date to the last 7 days or 9 days.

I don't want to manually specify the dates, as i want to use an automated program (expandit Launch Utility). to run a report whereby the script will put the current date minus the last 7 days transaction.

[/quote]

janebucik

You can do it like this:

SETFILTER("Posting Date",'%1..',WORKDATE-NoOfDays)

where NoOfDays is of type integer

Tommy_Schou

ajit wrote:

Hi,
Does anyone know how to set date range where by i want to access records from the current date to the last 7 days or 9 days.

I don't want to manually specify the dates, as i want to use an automated program (expandit Launch Utility). to run a report whereby the script will put the current date minus the last 7 days transaction.

CustLE.SETCURRENTKEY(Open,"Due Date");
CustLE.SETRANGE(Open,TRUE);
CustLE.SETRANGE("Due Date",TODAY,TODAY-7);
FORM.RUNMODAL(0,CustLE);

The above should do that. Just replace 7 by any old integer variable.