How to hide previous year in View column?

HCL Domino Domino Forum
1

I have a Start date column which I only want to show dates for the current year, not last years entries. The column is sorted by the previous column by Week

"Week “+@If(@Length(Weekassociated)>0;@Right(” “+Weekassociated;2);@If(@IsNumber(weekactual);@Right(” "+@Text(weekactual);2);“TBD”))

So it is showing entries for the same week for the last two years.

What formula can I use to only show 2004?

Thanks!

2

Subject: How to hide previous year in View column?

Three possible approaches:

1 View selection formula

Include something like DateField < “01/01/2004”. You will need to modify your view in January next year.

  1. Additional Category column

Insert an additional category column to the left with the formula @Year( DateField ). This will force the 2003 entries to sort under a separate twistie to the 2004 entries

  1. Run an agent which flags the documents to be excluded from the view.
3

Subject: RE: RE: How to hide previous year in View column?

You don’t have to hardcode the year, you can use something like @YEAR(@TODAY). A little drawback here is that the update symbol is displayed all the time when a function like @TODAY is used.

Klaus Bücher