customized date field in a filter doesn't work.

[Andrew K]

I've customized a date field as date()+60. It returns the desired date but
refreshes only when I manually recalculate (Calculation is set on Automatic).
I've put this date into a filter with the following condition: [Start] is
less than or equal to [Date10]. What are some of the reasons this filter
doesn't work?

 

[JulieS]

Hi Andrew,

I vaguely remember a similar post quite awhile ago and if I recall
correctly, using the Now() function instead of the Date() function
worked properly. The Now() function seems to update automatically.

I also did a quick test with a custom date field ([Date1]) and custom
filters and it worked.

The date ([Date1])field formula is:
ProjDateAdd(Now(),28800)

The filter is Start is less than or equal to [Date1]

I hope this helps. Let us know how you get along.

Julie

 

[Andrew K]

Beautiful! Thanks.

Hi Andrew,

I vaguely remember a similar post quite awhile ago and if I recall
correctly, using the Now() function instead of the Date() function
worked properly. The Now() function seems to update automatically.

I also did a quick test with a custom date field ([Date1]) and custom
filters and it worked.

The date ([Date1])field formula is:
ProjDateAdd(Now(),28800)

The filter is Start is less than or equal to [Date1]

I hope this helps. Let us know how you get along.

Julie

I've customized a date field as date()+60. It returns the desired
date but
refreshes only when I manually recalculate (Calculation is set on
Automatic).
I've put this date into a filter with the following condition:
[Start] is
less than or equal to [Date10]. What are some of the reasons this
filter
doesn't work?

 

[JulieS]

You're welcome Andrew and thanks for the feedback.

Julie

Beautiful! Thanks.

Hi Andrew,

I vaguely remember a similar post quite awhile ago and if I recall
correctly, using the Now() function instead of the Date() function
worked properly. The Now() function seems to update automatically.

I also did a quick test with a custom date field ([Date1]) and custom
filters and it worked.

The date ([Date1])field formula is:
ProjDateAdd(Now(),28800)

The filter is Start is less than or equal to [Date1]

I hope this helps. Let us know how you get along.

Julie

I've customized a date field as date()+60. It returns the desired
date but
refreshes only when I manually recalculate (Calculation is set on
Automatic).
I've put this date into a filter with the following condition:
[Start] is
less than or equal to [Date10]. What are some of the reasons this
filter
doesn't work?