Field with Multiple Date Values - How to display in View (Categorized)?

HCL Domino Domino Forum
1

Hi.

I have a Form with a multple date values field.

For eg.

Days : contains (28-Jan-05,29-Jan-05,30-Jan-05,31-Jan-05, 1st-Feb-05,2nd-Feb-05).

When I display in a view, categorized the column by “Days”, I’m able to split them display 6 separate entries.

But I can’t regrouped them into …

JAN 2005

---------28-Jan-05

---------29-Jan-05

---------30-Jan-05

---------31-Jan-05

Feb 2005

---------01-Feb-05

---------02-Feb-05

It will display as …

JAN 2005

---------28-Jan-05

---------29-Jan-05

---------30-Jan-05

---------31-Jan-05

---------01-Feb-05

---------02-Feb-05

Feb 2005

---------28-Jan-05

---------29-Jan-05

---------30-Jan-05

---------31-Jan-05

---------01-Feb-05

---------02-Feb-05

How to avoid that?

2

Subject: Field with Multiple Date Values - How to display in View (Categorized)?

To make it simple, and to avoid calculations in the view, create a separate, computed field, extracting only month + year.

HTH,

Simeon

3

Subject: Field with Multiple Date Values - How to display in View (Categorized)?

For your first column that is categorized, use this formula:

@Right(Days;“-”) + “\” + Days