Interview Question in Sharepoint Lists
Question :: MonkeyMan. Sharepoint Clerification |
I know, i know, i am DIFFICULT ahahaha. but you mis understood my question :(
you said
"Create a calculated field called secondtuesday with the formula:
=DATE(YEAR(Begin), MONTH(Begin), (8-WEEKDAY(DATE(YEAR(Begin), MONTH(Begin), 5))))+7
This will give you the second tuesday of the month of the begin date. Create a new view and filter out all of the items in your list where the second tuesday of the current month has passed."
but what i need is a way to hide all my items every second tuesday, biweekly, not every second tuesday of each month.
im sure the formula will look similar to this one you gave me before.
if that is the case, do i need to make a column for "date" "month" etc?
Thanks, hope there is an answer for this!
(ps, i put your name in the title so it catches your eye) :D
P |
|
|
|
Loading ...