I currently have a script that shows projects requiring work in a specif=
ic =

area today, which compares field DailySchedule::folder date <=3D //. I'd=
=

like to be able to view projects requiring work within the next week - b=
ut =

my attempts so far don't qualify as a valid date for comparison. // + 7 =
or =

get(currentdate) + 7 & variations of that. Any tips on how I should be =

formatting that "today + 7" statement?

Primarily FM7 clients sprinkled with FM8. Mac and PC, accessing the db o=
ff =

FMSA7.

Thanks in advance for any pointers.

Jim

"Jim Dornbos" <usenet [at] work.com> wrote in message
news:op.twq0v7arz6evoe [at] jdornbos...
I currently have a script that shows projects requiring work in a specific
area today, which compares field DailySchedule::folder date <= //. I'd
like to be able to view projects requiring work within the next week - but
my attempts so far don't qualify as a valid date for comparison. // + 7 or
get(currentdate) + 7 & variations of that. Any tips on how I should be
formatting that "today + 7" statement?

Primarily FM7 clients sprinkled with FM8. Mac and PC, accessing the db off
FMSA7.

Thanks in advance for any pointers.

Jim

-------------------------------------------------

set a global field in which you enter the days out, or hard code to various
scripts (7 days; 30 days, etc.) I use a pop-up with days and a go button

set a variable like "$ToDo" to DaysOut

Enter find mode

Insert calc value into you days out field

"Get(CurrentDate) & "..." & Get(CurrentDate)+$ToDo"


--
-------------------------------------------------
Captain Guy
s/v Island Time (Beneteau 352#277)
AICW 845.5
386-689-5088

"Jim Dornbos" <usenet [at] work.com> wrote in message
news:op.twq0v7arz6evoe [at] jdornbos...
I currently have a script that shows projects requiring work in a specific
area today, which compares field DailySchedule::folder date <= //. I'd
like to be able to view projects requiring work within the next week - but
my attempts so far don't qualify as a valid date for comparison. // + 7 or
get(currentdate) + 7 & variations of that. Any tips on how I should be
formatting that "today + 7" statement?

Primarily FM7 clients sprinkled with FM8. Mac and PC, accessing the db off
FMSA7.

Thanks in advance for any pointers.

Jim
-------------------------------------------------

set a global field in which you enter the days out, or hard code to various
scripts (7 days; 30 days, etc.) I use a pop-up with days and a go button

set a variable like "$ToDo" to DaysOut

Enter find mode

Insert calc value into you days out field

"Get(CurrentDate) & "..." & Get(CurrentDate)+$ToDo"


--
-------------------------------------------------
Captain Guy
s/v Island Time (Beneteau 352#277)
AICW 845.5
386-689-5088