Using formula to calc date as part of filter

[wendyB]

Hi,

How do you use a formula to calc dates as part of a filter? e.g.
Filter for tasks...
"Finish" greater than Current Date + 30days.
to filter out tasks that are finishing within the next 30 days.

Thanks
Wendy

 

[Brian K - Project MVP]

Hi,

How do you use a formula to calc dates as part of a filter? e.g.
Filter for tasks...
"Finish" greater than Current Date + 30days.
to filter out tasks that are finishing within the next 30 days.

Thanks
Wendy

Customize a field like Date1 and set the formula to: [Current Date] +30

Then create the filter to filter against Date1 instead of current date
+ 30

 

[wendyB]

Hi Brian

Thanks for your response.

Does this mean the filter syntax won't take formulas?

Regards
Wendy

Hi,

How do you use a formula to calc dates as part of a filter? e.g.
Filter for tasks...
"Finish" greater than Current Date + 30days.
to filter out tasks that are finishing within the next 30 days.

Thanks
Wendy

Customize a field like Date1 and set the formula to: [Current Date] +30

Then create the filter to filter against Date1 instead of current date
+ 30

 

[Gérard Ducouret]

Does this mean the filter syntax won't take formulas?

Exactly

Gérard

 

[Jan De Messemaeker]

Yes.

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620

Hi Brian

Thanks for your response.

Does this mean the filter syntax won't take formulas?

Regards
Wendy

Hi,

How do you use a formula to calc dates as part of a filter? e.g.
Filter for tasks...
"Finish" greater than Current Date + 30days.
to filter out tasks that are finishing within the next 30 days.

Thanks
Wendy

Customize a field like Date1 and set the formula to: [Current Date] +30

Then create the filter to filter against Date1 instead of current date
+ 30

 

[Brian K - Project MVP]

Hi Brian

Thanks for your response.

Does this mean the filter syntax won't take formulas?

Regards
Wendy

Hi,

How do you use a formula to calc dates as part of a filter? e.g.
Filter for tasks...
"Finish" greater than Current Date + 30days.
to filter out tasks that are finishing within the next 30 days.

Thanks
Wendy

Customize a field like Date1 and set the formula to: [Current Date]
+30

Then create the filter to filter against Date1 instead of current
date + 30

Not in the "Value(s)" field, not that I am aware of...

 

[wendyB]

Hi Brian
I used "[current date] + 30" in the formula in a Custom Date1 Field , but
this is giving me a syntax error.

What am I doing wrong?

Regards
Wendy

Hi,

How do you use a formula to calc dates as part of a filter? e.g.
Filter for tasks...
"Finish" greater than Current Date + 30days.
to filter out tasks that are finishing within the next 30 days.

Thanks
Wendy

Customize a field like Date1 and set the formula to: [Current Date] +30

Then create the filter to filter against Date1 instead of current date
+ 30

 

[Brian K - Project MVP]

Hi Brian
I used "[current date] + 30" in the formula in a Custom Date1 Field ,
but this is giving me a syntax error.

What am I doing wrong?

Regards
Wendy

Hi,

How do you use a formula to calc dates as part of a filter? e.g.
Filter for tasks...
"Finish" greater than Current Date + 30days.
to filter out tasks that are finishing within the next 30 days.

Thanks
Wendy

Customize a field like Date1 and set the formula to: [Current Date]
+30

Then create the filter to filter against Date1 instead of current
date + 30

Idont know what to say.
[Current Date]+30
Works fine for me.

 

[wendyB]

Hi Brian

Now I'm really curious.

I've managed to get the date field to work using [current date] and this was
what I was doing before:

1. Insert a Date1 field
2. Customize fields
3. Click on "Formula" under Custom Attributes in the Customize Fields dialog
4. Now()-90

Do you know that "now()" works any differently from "[Current Date]"?

Thanks
Wendy

Hi Brian
I used "[current date] + 30" in the formula in a Custom Date1 Field ,
but this is giving me a syntax error.

What am I doing wrong?

Regards
Wendy

wendyB wrote:

Hi,

How do you use a formula to calc dates as part of a filter? e.g.
Filter for tasks...
"Finish" greater than Current Date + 30days.
to filter out tasks that are finishing within the next 30 days.

Thanks
Wendy

Customize a field like Date1 and set the formula to: [Current Date]
+30

Then create the filter to filter against Date1 instead of current
date + 30

Idont know what to say.
[Current Date]+30
Works fine for me.

 

[Brian K - Project MVP]

Hi Brian

Now I'm really curious.

I've managed to get the date field to work using [current date] and
this was what I was doing before:

1. Insert a Date1 field
2. Customize fields
3. Click on "Formula" under Custom Attributes in the Customize Fields
dialog 4. Now()-90

Do you know that "now()" works any differently from "[Current Date]"?

Thanks
Wendy

Hi Brian
I used "[current date] + 30" in the formula in a Custom Date1
Field , but this is giving me a syntax error.

What am I doing wrong?

Regards
Wendy


:

wendyB wrote:

Hi,

How do you use a formula to calc dates as part of a filter?
e.g. Filter for tasks...
"Finish" greater than Current Date + 30days.
to filter out tasks that are finishing within the next 30
days.

Thanks
Wendy

Customize a field like Date1 and set the formula to: [Current
Date] +30

Then create the filter to filter against Date1 instead of
current date + 30

Idont know what to say.
[Current Date]+30
Works fine for me.

Now() includes the time also. That might have been the trouble. Not
sure. Im glad it is working now though!