next seven day search

[ukmgranger]

Hi all,

Please be gentle I am a newb!

I need to generate a report that only shows me clients that have a job booked in within the next seven days.

How do I set up a script to do this?

Thanks in advance!!

Edited November 12, 2007 by Guest

[aldipalo]

Enter find mode() /* pause unchecked

Set Field(datefield; get(currentdate)& "..."& Get (Currentdate)+ 7)

Or set up 2 new date fields:

Startdate

enddate

/* Of course you need to have these fields on the layout and need to input the dates prior to running the script. You could make them a calc field. StartDate = Get(Currentdate); enddate=get(currentdate + 7) */

Set Field(datefield;startdate &"..." & enddate)

Perform Find()

Edited November 12, 2007 by Guest

[Haifisch]

Hi

I'm jumping on the train right here, as I have a similar question:

I want to see all entries which are older than 180 days.

I tried the following script, but without success:

Action: Find records

find criteria: Date﹝≤(//-180)﹞

No success, all of the entries appear (even these younger than 180 days.

Is it possible like this?

Thanks in advance for any comments.

Harry

[The Shadow]

The "//" unfortunately doesn't work like that.

You'll need a script more like aldipalo shows, with something like:

  Set Field( dateField; "<=" & Get(CurrentDate) - 180 )

as your dynamic find criteria.