Filter tasks for next 4 weeks or 3 months + Logical Operators...HELP

T

Thomas

Hi all,

can anyone help (or improve) the following approach?

My intention is to create a filter for all tasks in
a) next 4 weeks
b) next 3 months


So I calculate the following dates

Start2 = ProjDateAdd(Now();9600) <--- approx. next 4 weeks
Start3 = ProjDateAdd(Now();28800) <--- approx. next 3 months

and compare them in order to use a filter with these flags.

Flag1 = IIf([Start]>Now();IIf([Start]<[Start2];1;0);0)
Flag2 = IIf([End]>Now();IIf([End]<[Start2];1;0);0)
Flag3 = [Flag1] or [Flag2]
--> next 4 weeks

Flag3 = IIf([Start]>Now();IIf([Start]<[Start3];1;0);0)
Flag4 = IIf([End]>Now();IIf([End]<[Start3];1;0);0)
Flag5 = [Flag3] or [Flag4]
--> next 3 months

IN GENERAL....
Why can't I go the following way, in order to save fields in
enterprise global?

Flag3 = IIf([Start]>Now();IIf([Start]<[Start2];1;0);0) OR
IIf([End]>Now();IIf([End]<[Start2];1;0);0)
--> ERROR MESSAGE

Flag5 = IIf([Start]>Now();IIf([Start]<[Start3];1;0);0) OR
IIf([End]>Now();IIf([End]<[Start3];1;0);0)
--> ERROR MESSAGE


If this would work I also could use only ONE flag without calculated
dates for each filter...like...
Flag3 = IIf([Start]>Now();IIf([Start]<ProjDateAdd(Now();9600);1;0);0)
OR IIf([End]>Now();IIf([End]<ProjDateAdd(Now();9600);1;0);0)


Any comments?
Any (other) ideas how to get this to work?
Any (other) ideas for an easy filter for next 4 weeks or next 3
months?

HELP :)
Thomas

PS: We're using Project / Project Server 2003
 
G

Guest

can i use these formulas within project?



Scott M Wagner - MVP said:
Thomas,

Do you know how to use DateDiff that would be a better approach.
If you need help check out:

http://infocenter.sybase.com/help/i...elp.ase_15.0.blocks/html/blocks/blocks137.htm
or

http://tutor.petech.ac.za/rudi/2002/WIH2122/LectureNotes/SQLNotes/useful_sql_functions.htm

Thanks,


Thomas said:
Hi all,

can anyone help (or improve) the following approach?

My intention is to create a filter for all tasks in
a) next 4 weeks
b) next 3 months


So I calculate the following dates

Start2 = ProjDateAdd(Now();9600) <--- approx. next 4 weeks
Start3 = ProjDateAdd(Now();28800) <--- approx. next 3 months

and compare them in order to use a filter with these flags.

Flag1 = IIf([Start]>Now();IIf([Start]<[Start2];1;0);0)
Flag2 = IIf([End]>Now();IIf([End]<[Start2];1;0);0)
Flag3 = [Flag1] or [Flag2]
--> next 4 weeks

Flag3 = IIf([Start]>Now();IIf([Start]<[Start3];1;0);0)
Flag4 = IIf([End]>Now();IIf([End]<[Start3];1;0);0)
Flag5 = [Flag3] or [Flag4]
--> next 3 months

IN GENERAL....
Why can't I go the following way, in order to save fields in
enterprise global?

Flag3 = IIf([Start]>Now();IIf([Start]<[Start2];1;0);0) OR
IIf([End]>Now();IIf([End]<[Start2];1;0);0)
--> ERROR MESSAGE

Flag5 = IIf([Start]>Now();IIf([Start]<[Start3];1;0);0) OR
IIf([End]>Now();IIf([End]<[Start3];1;0);0)
--> ERROR MESSAGE


If this would work I also could use only ONE flag without calculated
dates for each filter...like...
Flag3 = IIf([Start]>Now();IIf([Start]<ProjDateAdd(Now();9600);1;0);0)
OR IIf([End]>Now();IIf([End]<ProjDateAdd(Now();9600);1;0);0)


Any comments?
Any (other) ideas how to get this to work?
Any (other) ideas for an easy filter for next 4 weeks or next 3
months?

HELP :)
Thomas

PS: We're using Project / Project Server 2003
Click to expand...
Click to expand...
 
S

Scott M Wagner - MVP

Here you go:

VBA DateDiff Function

The VB DateDiff function returns a variant variable result of subtracting
two dates. The unit of measure is defined in the interval argument.

Syntax

DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]])

Arguments:

interval - Required. String expression that is the interval of time you use
to calculate the difference between date1 and date2. See a list of valid
intervals in the DateAdd function above.

date1, date2 - Required; Variant (Date). Two dates you want to use in the
calculation.

firstdayofweek - Optional. A constant that specifies the first day of the
week. If not specified, Sunday is assumed.

firstweekofyear - Optional. A constant that specifies the first week of the
year. If not specified, the first week is assumed to be the week in which
January 1 occurs.

Example:

MsgBox DateDiff("yyyy", "01/01/2005", "11/11/2006")

Above displays '1'.



[email protected] said:
can i use these formulas within project?



Scott M Wagner - MVP said:
Thomas,

Do you know how to use DateDiff that would be a better approach.
If you need help check out:

http://infocenter.sybase.com/help/i...elp.ase_15.0.blocks/html/blocks/blocks137.htm
or

http://tutor.petech.ac.za/rudi/2002/WIH2122/LectureNotes/SQLNotes/useful_sql_functions.htm

Thanks,


Thomas said:
Hi all,

can anyone help (or improve) the following approach?

My intention is to create a filter for all tasks in
a) next 4 weeks
b) next 3 months


So I calculate the following dates

Start2 = ProjDateAdd(Now();9600) <--- approx. next 4 weeks
Start3 = ProjDateAdd(Now();28800) <--- approx. next 3 months

and compare them in order to use a filter with these flags.

Flag1 = IIf([Start]>Now();IIf([Start]<[Start2];1;0);0)
Flag2 = IIf([End]>Now();IIf([End]<[Start2];1;0);0)
Flag3 = [Flag1] or [Flag2]
--> next 4 weeks

Flag3 = IIf([Start]>Now();IIf([Start]<[Start3];1;0);0)
Flag4 = IIf([End]>Now();IIf([End]<[Start3];1;0);0)
Flag5 = [Flag3] or [Flag4]
--> next 3 months

IN GENERAL....
Why can't I go the following way, in order to save fields in
enterprise global?

Flag3 = IIf([Start]>Now();IIf([Start]<[Start2];1;0);0) OR
IIf([End]>Now();IIf([End]<[Start2];1;0);0)
--> ERROR MESSAGE

Flag5 = IIf([Start]>Now();IIf([Start]<[Start3];1;0);0) OR
IIf([End]>Now();IIf([End]<[Start3];1;0);0)
--> ERROR MESSAGE


If this would work I also could use only ONE flag without calculated
dates for each filter...like...
Flag3 = IIf([Start]>Now();IIf([Start]<ProjDateAdd(Now();9600);1;0);0)
OR IIf([End]>Now();IIf([End]<ProjDateAdd(Now();9600);1;0);0)


Any comments?
Any (other) ideas how to get this to work?
Any (other) ideas for an easy filter for next 4 weeks or next 3
months?

HELP :)
Thomas

PS: We're using Project / Project Server 2003
Click to expand...
Click to expand...
Click to expand...
 
G

Guest

Thanks!

But to come back to one of my other questions...

Can't I combine...

Flag5 = IIf([Start]>Now();IIf([Start]<[Start3];1;0);0) OR
IIf([End]>Now();IIf([End]<[Start3];1;0);0)

without
--> ERROR MESSAGE



Scott M Wagner - MVP said:
Here you go:

VBA DateDiff Function

The VB DateDiff function returns a variant variable result of subtracting
two dates. The unit of measure is defined in the interval argument.

Syntax

DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]])

Arguments:

interval - Required. String expression that is the interval of time you
use
to calculate the difference between date1 and date2. See a list of valid
intervals in the DateAdd function above.

date1, date2 - Required; Variant (Date). Two dates you want to use in the
calculation.

firstdayofweek - Optional. A constant that specifies the first day of the
week. If not specified, Sunday is assumed.

firstweekofyear - Optional. A constant that specifies the first week of
the
year. If not specified, the first week is assumed to be the week in which
January 1 occurs.

Example:

MsgBox DateDiff("yyyy", "01/01/2005", "11/11/2006")

Above displays '1'.



[email protected] said:
can i use these formulas within project?



"Scott M Wagner - MVP" <[email protected]>
schrieb
im Newsbeitrag news:D[email protected]...
Thomas,

Do you know how to use DateDiff that would be a better approach.
If you need help check out:

http://infocenter.sybase.com/help/i...elp.ase_15.0.blocks/html/blocks/blocks137.htm
or

http://tutor.petech.ac.za/rudi/2002/WIH2122/LectureNotes/SQLNotes/useful_sql_functions.htm

Thanks,


:

Hi all,

can anyone help (or improve) the following approach?

My intention is to create a filter for all tasks in
a) next 4 weeks
b) next 3 months


So I calculate the following dates

Start2 = ProjDateAdd(Now();9600) <--- approx. next 4 weeks
Start3 = ProjDateAdd(Now();28800) <--- approx. next 3 months

and compare them in order to use a filter with these flags.

Flag1 = IIf([Start]>Now();IIf([Start]<[Start2];1;0);0)
Flag2 = IIf([End]>Now();IIf([End]<[Start2];1;0);0)
Flag3 = [Flag1] or [Flag2]
--> next 4 weeks

Flag3 = IIf([Start]>Now();IIf([Start]<[Start3];1;0);0)
Flag4 = IIf([End]>Now();IIf([End]<[Start3];1;0);0)
Flag5 = [Flag3] or [Flag4]
--> next 3 months

IN GENERAL....
Why can't I go the following way, in order to save fields in
enterprise global?

Flag3 = IIf([Start]>Now();IIf([Start]<[Start2];1;0);0) OR
IIf([End]>Now();IIf([End]<[Start2];1;0);0)
--> ERROR MESSAGE

Flag5 = IIf([Start]>Now();IIf([Start]<[Start3];1;0);0) OR
IIf([End]>Now();IIf([End]<[Start3];1;0);0)
--> ERROR MESSAGE


If this would work I also could use only ONE flag without calculated
dates for each filter...like...
Flag3 = IIf([Start]>Now();IIf([Start]<ProjDateAdd(Now();9600);1;0);0)
OR IIf([End]>Now();IIf([End]<ProjDateAdd(Now();9600);1;0);0)


Any comments?
Any (other) ideas how to get this to work?
Any (other) ideas for an easy filter for next 4 weeks or next 3
months?

HELP :)
Thomas

PS: We're using Project / Project Server 2003
Click to expand...
Click to expand...
Click to expand...
 
J

Jack Dahlgren

VBA and custom field formula functions have slightly different names.
DateDiff in VBA is the same as ProjDateDiff in a custom field formula.

ProjDateAdd looks to me to be most appropriate for what you are trying to
do.
All the "Projxxxxx" date functions take the project calendar into account.

-Jack Dahlgren

Scott M Wagner - MVP said:
Here you go:

VBA DateDiff Function

The VB DateDiff function returns a variant variable result of subtracting
two dates. The unit of measure is defined in the interval argument.

Syntax

DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]])

Arguments:

interval - Required. String expression that is the interval of time you
use
to calculate the difference between date1 and date2. See a list of valid
intervals in the DateAdd function above.

date1, date2 - Required; Variant (Date). Two dates you want to use in the
calculation.

firstdayofweek - Optional. A constant that specifies the first day of the
week. If not specified, Sunday is assumed.

firstweekofyear - Optional. A constant that specifies the first week of
the
year. If not specified, the first week is assumed to be the week in which
January 1 occurs.

Example:

MsgBox DateDiff("yyyy", "01/01/2005", "11/11/2006")

Above displays '1'.



[email protected] said:
can i use these formulas within project?



"Scott M Wagner - MVP" <[email protected]>
schrieb
im Newsbeitrag news:D[email protected]...
Thomas,

Do you know how to use DateDiff that would be a better approach.
If you need help check out:

http://infocenter.sybase.com/help/i...elp.ase_15.0.blocks/html/blocks/blocks137.htm
or

http://tutor.petech.ac.za/rudi/2002/WIH2122/LectureNotes/SQLNotes/useful_sql_functions.htm

Thanks,


:

Hi all,

can anyone help (or improve) the following approach?

My intention is to create a filter for all tasks in
a) next 4 weeks
b) next 3 months


So I calculate the following dates

Start2 = ProjDateAdd(Now();9600) <--- approx. next 4 weeks
Start3 = ProjDateAdd(Now();28800) <--- approx. next 3 months

and compare them in order to use a filter with these flags.

Flag1 = IIf([Start]>Now();IIf([Start]<[Start2];1;0);0)
Flag2 = IIf([End]>Now();IIf([End]<[Start2];1;0);0)
Flag3 = [Flag1] or [Flag2]
--> next 4 weeks

Flag3 = IIf([Start]>Now();IIf([Start]<[Start3];1;0);0)
Flag4 = IIf([End]>Now();IIf([End]<[Start3];1;0);0)
Flag5 = [Flag3] or [Flag4]
--> next 3 months

IN GENERAL....
Why can't I go the following way, in order to save fields in
enterprise global?

Flag3 = IIf([Start]>Now();IIf([Start]<[Start2];1;0);0) OR
IIf([End]>Now();IIf([End]<[Start2];1;0);0)
--> ERROR MESSAGE

Flag5 = IIf([Start]>Now();IIf([Start]<[Start3];1;0);0) OR
IIf([End]>Now();IIf([End]<[Start3];1;0);0)
--> ERROR MESSAGE


If this would work I also could use only ONE flag without calculated
dates for each filter...like...
Flag3 = IIf([Start]>Now();IIf([Start]<ProjDateAdd(Now();9600);1;0);0)
OR IIf([End]>Now();IIf([End]<ProjDateAdd(Now();9600);1;0);0)


Any comments?
Any (other) ideas how to get this to work?
Any (other) ideas for an easy filter for next 4 weeks or next 3
months?

HELP :)
Thomas

PS: We're using Project / Project Server 2003
Click to expand...
Click to expand...
Click to expand...
 
J

Jack Dahlgren

You might try using a comma , instead of a semi-colon ; in your formula.

-Jack Dahlgren

Thanks!

But to come back to one of my other questions...

Can't I combine...

Flag5 = IIf([Start]>Now();IIf([Start]<[Start3];1;0);0) OR
IIf([End]>Now();IIf([End]<[Start3];1;0);0)

without
--> ERROR MESSAGE



Scott M Wagner - MVP said:
Here you go:

VBA DateDiff Function

The VB DateDiff function returns a variant variable result of subtracting
two dates. The unit of measure is defined in the interval argument.

Syntax

DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]])

Arguments:

interval - Required. String expression that is the interval of time you
use
to calculate the difference between date1 and date2. See a list of valid
intervals in the DateAdd function above.

date1, date2 - Required; Variant (Date). Two dates you want to use in the
calculation.

firstdayofweek - Optional. A constant that specifies the first day of the
week. If not specified, Sunday is assumed.

firstweekofyear - Optional. A constant that specifies the first week of
the
year. If not specified, the first week is assumed to be the week in which
January 1 occurs.

Example:

MsgBox DateDiff("yyyy", "01/01/2005", "11/11/2006")

Above displays '1'.



[email protected] said:
can i use these formulas within project?



"Scott M Wagner - MVP" <[email protected]>
schrieb
im Newsbeitrag
Thomas,

Do you know how to use DateDiff that would be a better approach.
If you need help check out:

http://infocenter.sybase.com/help/i...elp.ase_15.0.blocks/html/blocks/blocks137.htm
or

http://tutor.petech.ac.za/rudi/2002/WIH2122/LectureNotes/SQLNotes/useful_sql_functions.htm

Thanks,


:

Hi all,

can anyone help (or improve) the following approach?

My intention is to create a filter for all tasks in
a) next 4 weeks
b) next 3 months


So I calculate the following dates

Start2 = ProjDateAdd(Now();9600) <--- approx. next 4 weeks
Start3 = ProjDateAdd(Now();28800) <--- approx. next 3 months

and compare them in order to use a filter with these flags.

Flag1 = IIf([Start]>Now();IIf([Start]<[Start2];1;0);0)
Flag2 = IIf([End]>Now();IIf([End]<[Start2];1;0);0)
Flag3 = [Flag1] or [Flag2]
--> next 4 weeks

Flag3 = IIf([Start]>Now();IIf([Start]<[Start3];1;0);0)
Flag4 = IIf([End]>Now();IIf([End]<[Start3];1;0);0)
Flag5 = [Flag3] or [Flag4]
--> next 3 months

IN GENERAL....
Why can't I go the following way, in order to save fields in
enterprise global?

Flag3 = IIf([Start]>Now();IIf([Start]<[Start2];1;0);0) OR
IIf([End]>Now();IIf([End]<[Start2];1;0);0)
--> ERROR MESSAGE

Flag5 = IIf([Start]>Now();IIf([Start]<[Start3];1;0);0) OR
IIf([End]>Now();IIf([End]<[Start3];1;0);0)
--> ERROR MESSAGE


If this would work I also could use only ONE flag without calculated
dates for each filter...like...
Flag3 = IIf([Start]>Now();IIf([Start]<ProjDateAdd(Now();9600);1;0);0)
OR IIf([End]>Now();IIf([End]<ProjDateAdd(Now();9600);1;0);0)


Any comments?
Any (other) ideas how to get this to work?
Any (other) ideas for an easy filter for next 4 weeks or next 3
months?

HELP :)
Thomas

PS: We're using Project / Project Server 2003
Click to expand...
Click to expand...
Click to expand...
 
T

Thomas

You might try using a comma , instead of a semi-colon ; in your formula.

-Jack Dahlgren




Thanks!
Click to expand...
But to come back to one of my other questions...
Click to expand...
Can't I combine...
Click to expand...
Flag5 = IIf([Start]>Now();IIf([Start]<[Start3];1;0);0) OR
IIf([End]>Now();IIf([End]<[Start3];1;0);0)
Click to expand...
without
--> ERROR MESSAGE
Click to expand...
Scott M Wagner - MVP said:
Here you go:
VBA DateDiff Function
The VB DateDiff function returns a variant variable result of subtracting
two dates.  The unit of measure is defined in the interval argument.
Syntax
DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]])
Arguments:
interval - Required. String expression that is the interval of time you
use
to calculate the difference between date1 and date2. See a list of valid
intervals in the DateAdd function above.
date1, date2 - Required; Variant (Date). Two dates you want to use in the
calculation.
firstdayofweek - Optional. A constant that specifies the first day of the
week. If not specified, Sunday is assumed.
firstweekofyear - Optional. A constant that specifies the first week of
the
year. If not specified, the first week is assumed to be the week in which
January 1 occurs.
Example:
MsgBox DateDiff("yyyy", "01/01/2005", "11/11/2006")
Above displays '1'.
:
can i use these formulas within project?
"Scott M Wagner - MVP" <[email protected]>
schrieb
im Newsbeitrag
Thomas,
Do you know how to use DateDiff that would be a better approach.
If you need help check out:
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.as...
or
http://tutor.petech.ac.za/rudi/2002/WIH2122/LectureNotes/SQLNotes/use....
Thanks,
:
Hi all,
can anyone help (or improve) the following approach?
My intention is to create a filter for all tasks in
      a) next 4 weeks
      b) next 3 months
So I calculate the following dates
Start2 = ProjDateAdd(Now();9600)        <--- approx. next4 weeks
Start3 = ProjDateAdd(Now();28800)      <--- approx. next 3 months
and compare them in order to use a filter with these flags.
Flag1 = IIf([Start]>Now();IIf([Start]<[Start2];1;0);0)
Flag2 = IIf([End]>Now();IIf([End]<[Start2];1;0);0)
Flag3 = [Flag1] or [Flag2]
--> next 4 weeks
Flag3 = IIf([Start]>Now();IIf([Start]<[Start3];1;0);0)
Flag4 = IIf([End]>Now();IIf([End]<[Start3];1;0);0)
Flag5 = [Flag3] or [Flag4]
--> next 3 months
IN GENERAL....
Why can't I go the following way, in order to save fields in
enterprise global?
Flag3 = IIf([Start]>Now();IIf([Start]<[Start2];1;0);0) OR
IIf([End]>Now();IIf([End]<[Start2];1;0);0)
--> ERROR MESSAGE
Flag5 = IIf([Start]>Now();IIf([Start]<[Start3];1;0);0) OR
IIf([End]>Now();IIf([End]<[Start3];1;0);0)
--> ERROR MESSAGE
If this would work I also could use only ONE flag without calculated
dates for each filter...like...
Flag3 = IIf([Start]>Now();IIf([Start]<ProjDateAdd(Now();9600);1;0);0)
OR IIf([End]>Now();IIf([End]<ProjDateAdd(Now();9600);1;0);0)
Any comments?
Any (other) ideas how to get this to work?
Any (other) ideas for an easy filter for next 4 weeks or next 3
months?
HELP :)
Thomas
PS: We're using Project / Project Server 2003- Hide quoted text -
Click to expand...
Click to expand...

- Show quoted text -
Click to expand...


comma does not work....is it not possible to combine these two
formulas?

Flag5 = IIf([Start]>Now();IIf([Start]<[Start3];1;0);0) OR
IIf([End]>Now();IIf([End]<[Start3];1;0);0)
 
J

Jack Dahlgren

It appears that we have a different version of Project, but the following
formula works for me:

Note that it uses "Finish" not "End"

IIf([Start]>Now(),IIf([Start]<[Start3],1,0),0) Or
IIf([Finish]>Now(),IIf([Finish]<[Start3],1,0),0)

-Jack Dahlgren


You might try using a comma , instead of a semi-colon ; in your formula.

-Jack Dahlgren




Thanks!
Click to expand...
But to come back to one of my other questions...
Click to expand...
Can't I combine...
Click to expand...
Flag5 = IIf([Start]>Now();IIf([Start]<[Start3];1;0);0) OR
IIf([End]>Now();IIf([End]<[Start3];1;0);0)
Click to expand...
without
--> ERROR MESSAGE
Click to expand...
"Scott M Wagner - MVP" <[email protected]>
schrieb
im Newsbeitragnews:[email protected]...
Here you go:
VBA DateDiff Function
The VB DateDiff function returns a variant variable result of
subtracting
two dates. The unit of measure is defined in the interval argument.
Syntax
DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]])
Arguments:
interval - Required. String expression that is the interval of time you
use
to calculate the difference between date1 and date2. See a list of
valid
intervals in the DateAdd function above.
date1, date2 - Required; Variant (Date). Two dates you want to use in
the
calculation.
firstdayofweek - Optional. A constant that specifies the first day of
the
week. If not specified, Sunday is assumed.
firstweekofyear - Optional. A constant that specifies the first week of
the
year. If not specified, the first week is assumed to be the week in
which
January 1 occurs.
Example:
MsgBox DateDiff("yyyy", "01/01/2005", "11/11/2006")
Above displays '1'.
:
can i use these formulas within project?
"Scott M Wagner - MVP" <[email protected]>
schrieb
im Newsbeitrag
Thomas,
Do you know how to use DateDiff that would be a better approach.
If you need help check out:
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.as...
or
http://tutor.petech.ac.za/rudi/2002/WIH2122/LectureNotes/SQLNotes/use...
Thanks,
:
Hi all,
can anyone help (or improve) the following approach?
My intention is to create a filter for all tasks in
a) next 4 weeks
b) next 3 months
So I calculate the following dates
Start2 = ProjDateAdd(Now();9600) <--- approx. next 4 weeks
Start3 = ProjDateAdd(Now();28800) <--- approx. next 3 months
and compare them in order to use a filter with these flags.
Flag1 = IIf([Start]>Now();IIf([Start]<[Start2];1;0);0)
Flag2 = IIf([End]>Now();IIf([End]<[Start2];1;0);0)
Flag3 = [Flag1] or [Flag2]
--> next 4 weeks
Flag3 = IIf([Start]>Now();IIf([Start]<[Start3];1;0);0)
Flag4 = IIf([End]>Now();IIf([End]<[Start3];1;0);0)
Flag5 = [Flag3] or [Flag4]
--> next 3 months
IN GENERAL....
Why can't I go the following way, in order to save fields in
enterprise global?
Flag3 = IIf([Start]>Now();IIf([Start]<[Start2];1;0);0) OR
IIf([End]>Now();IIf([End]<[Start2];1;0);0)
--> ERROR MESSAGE
Flag5 = IIf([Start]>Now();IIf([Start]<[Start3];1;0);0) OR
IIf([End]>Now();IIf([End]<[Start3];1;0);0)
--> ERROR MESSAGE
If this would work I also could use only ONE flag without
calculated
dates for each filter...like...
Flag3 =
IIf([Start]>Now();IIf([Start]<ProjDateAdd(Now();9600);1;0);0)
OR IIf([End]>Now();IIf([End]<ProjDateAdd(Now();9600);1;0);0)
Any comments?
Any (other) ideas how to get this to work?
Any (other) ideas for an easy filter for next 4 weeks or next 3
months?
HELP :)
Thomas
PS: We're using Project / Project Server 2003- Hide quoted text -
Click to expand...
Click to expand...

- Show quoted text -
Click to expand...


comma does not work....is it not possible to combine these two
formulas?

Flag5 = IIf([Start]>Now();IIf([Start]<[Start3];1;0);0) OR
IIf([End]>Now();IIf([End]<[Start3];1;0);0)
 
T

Thomas

Jack,

of course we're using the same tool....maybe only in different
languages... :)

This works...

IIf([Anfang]>[Anfang1];IIf([Anfang]<[Anfang2];1;0);0) Or
IIf([Ende]>[Anfang1],IIf([Ende]<[Anfang2],1,0),0)

I did not know that first part can use semicolon and second part has
to use comma!?
And that was also the reason why I kept on asking for this.

Now we could start discussion if this is the easiest way to use this
filter (next 4 weeks or next 3 months). :)

Thanks!
Thomas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Populating datasheet using search criteria.... 0
PWA2003: show next 4 weeks 4
Project 2007 Resource Assignment Bug? 7
Macro Expert's 1
For Next If help 3
Import 1, 3, 6, and 12 month returns for a list of mutual funds 8
Restore and Recover lost or deleted Microsoft Word Document 0

Top