| Author |
Message |
Marian Pierre-Louis
Guest
|
 Posted:
Fri Jan 14, 2005 9:42 pm Post subject:
Filtering list views by date |
|
|
Is it possible to create a view for Tasks so that the only
tasks that display are due within the next 7 days? Is
there a formular or something for this?
Thanks!
Marian |
|
| Back to top |
|
 |
tedteng
Guest
|
| Posted:
Sat Jan 15, 2005 12:21 pm Post subject:
RE: Filtering list views by date |
|
|
Yes, it is a bit carzy the sps does not allow such fucntion like [Today]+7. I
thought it should be ok. So the work around for ur requirment is to add a new
column "DueDate7" which is a caculated type filed adn its value set to
[DueDate]+7.
Then create a new view say, Due In Next & Days, fitler the DueDate7 field
with [Today].
Hope it works for u.
br
ted
"Marian Pierre-Louis" wrote:
| Quote: | Is it possible to create a view for Tasks so that the only
tasks that display are due within the next 7 days? Is
there a formular or something for this?
Thanks!
Marian
|
|
|
| Back to top |
|
|
tedteng
Guest
|
| Posted:
Mon Jan 17, 2005 6:15 pm Post subject:
RE: Filtering list views by date |
|
|
I have a new idea to complete it. I will write the detailed steps to achive
this without adding computed colmun.
I will come back to this post when done.
br
ted
"tedteng" wrote:
| Quote: | Yes, it is a bit carzy the sps does not allow such fucntion like [Today]+7. I
thought it should be ok. So the work around for ur requirment is to add a new
column "DueDate7" which is a caculated type filed adn its value set to
[DueDate]+7.
Then create a new view say, Due In Next & Days, fitler the DueDate7 field
with [Today].
Hope it works for u.
br
ted
"Marian Pierre-Louis" wrote:
Is it possible to create a view for Tasks so that the only
tasks that display are due within the next 7 days? Is
there a formular or something for this?
Thanks!
Marian
|
|
|
| Back to top |
|
|
Guest
|
| Posted:
Mon Jan 17, 2005 6:15 pm Post subject:
RE: Filtering list views by date |
|
|
Thank you! I appreciate you help and look forward to your
response.
Marian
| Quote: | -----Original Message-----
I have a new idea to complete it. I will write the
detailed steps to achive
this without adding computed colmun.
I will come back to this post when done.
br
ted
"tedteng" wrote:
Yes, it is a bit carzy the sps does not allow such
fucntion like [Today]+7. I
thought it should be ok. So the work around for ur
requirment is to add a new
column "DueDate7" which is a caculated type filed adn
its value set to
[DueDate]+7.
Then create a new view say, Due In Next & Days, fitler
the DueDate7 field
with [Today].
Hope it works for u.
br
ted
"Marian Pierre-Louis" wrote:
Is it possible to create a view for Tasks so that the
only
tasks that display are due within the next 7 days?
Is
there a formular or something for this?
Thanks!
Marian
.
|
|
|
| Back to top |
|
|
tedteng
Guest
|
| Posted:
Wed Jan 19, 2005 6:49 am Post subject:
RE: Filtering list views by date |
|
|
I thought ur request is similar to CZS:
http://ms.mblogger.cn/tedteng/posts/12391.aspx
How to ONLY Display "This Month" Items in a List (2005-01-20)
U can use this mentod to change ur filter to this week, but not today+7,
sorry again fo no solution on ur case so far.
br
ted
"tedteng" wrote:
| Quote: | Really sorry. I failed. What only I can do is to filter "This Week" and "This
Month", not "Today+7".
So still pls follow this post for ur requirement.
http://dev.collutions.com/blog/DisplayPost.aspx?ID=12
br
ted
"anonymous@discussions.microsoft.com" wrote:
Thank you! I appreciate you help and look forward to your
response.
Marian
-----Original Message-----
I have a new idea to complete it. I will write the
detailed steps to achive
this without adding computed colmun.
I will come back to this post when done.
br
ted
"tedteng" wrote:
Yes, it is a bit carzy the sps does not allow such
fucntion like [Today]+7. I
thought it should be ok. So the work around for ur
requirment is to add a new
column "DueDate7" which is a caculated type filed adn
its value set to
[DueDate]+7.
Then create a new view say, Due In Next & Days, fitler
the DueDate7 field
with [Today].
Hope it works for u.
br
ted
"Marian Pierre-Louis" wrote:
Is it possible to create a view for Tasks so that the
only
tasks that display are due within the next 7 days?
Is
there a formular or something for this?
Thanks!
Marian
.
|
|
|
| Back to top |
|
|
tedteng
Guest
|
| Posted:
Wed Jan 19, 2005 6:49 am Post subject:
RE: Filtering list views by date |
|
|
Really sorry. I failed. What only I can do is to filter "This Week" and "This
Month", not "Today+7".
So still pls follow this post for ur requirement.
http://dev.collutions.com/blog/DisplayPost.aspx?ID=12
br
ted
"anonymous@discussions.microsoft.com" wrote:
| Quote: | Thank you! I appreciate you help and look forward to your
response.
Marian
-----Original Message-----
I have a new idea to complete it. I will write the
detailed steps to achive
this without adding computed colmun.
I will come back to this post when done.
br
ted
"tedteng" wrote:
Yes, it is a bit carzy the sps does not allow such
fucntion like [Today]+7. I
thought it should be ok. So the work around for ur
requirment is to add a new
column "DueDate7" which is a caculated type filed adn
its value set to
[DueDate]+7.
Then create a new view say, Due In Next & Days, fitler
the DueDate7 field
with [Today].
Hope it works for u.
br
ted
"Marian Pierre-Louis" wrote:
Is it possible to create a view for Tasks so that the
only
tasks that display are due within the next 7 days?
Is
there a formular or something for this?
Thanks!
Marian
.
|
|
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in