multibox date field is showing duplicate records

[Anonymous]

Hi ,

In my multibox date field record having showing same values multiple times.

can you help to see only one value for one mon-yyyy.

please find the sample qvw for reference.

Thanks,

Q Kumar

[Chanty4u]

hi

PFA,

[marcus_sommer]

You need to take a real YearMonth field and not formatting a date-field which then has of course several different values for thi s format. Recommended is for tis to use a master-calendar: How to use - Master-Calendar and Date-Values

- Marcus

[Anonymous]

Suresh,

i want to see unique MMM-YYYY values in the field of multibox, but not the entire dates.

in some approaches i am getting Duplicate MMM-YYYY values like:

JAN-2015

JAN-2015

FEB-2015

But i wanna result like below:

DEC-2014

JAN-2015

FEB-2015

Tahnks,

Ravi

[roger_stone]

You could use an expression in the multiBox and label it DateRec, with the expression:

=MONTH(DateRec) & '-' & YEAR(DateRec)