CODEWITHSUNDEEP
lotus-noteslotus-domino
hjh93
hjh93

Reputation: 570

How to set multiple date fields as value for a single column view?

In my form, there are 3 tables, each with a column for dates field.

The date field names are:

CertEnd, CertEnd_1, ..., CertEnd_9
CQIEnd, CQIEnd_1, ..., CQIEnd_4
InspEnd, InspEnd_1, ..., InspEnd_4

When I create my view, I set up 1 column for Date and was hoping I can select all the fields stated above. But I can only select one it seems.

Then I try using formula. testing with the 1st date field from all 3 tables:

CertEnd;
CQIEnd;
InspEnd

All that did was give me the date for InspEnd in the view. How can I get it to show all 3 dates?

Upvotes: 0

Views: 57

Answers (1)

Per Henrik Lausten
Per Henrik Lausten

Reputation: 21709

You can use : (colon) to separate the fields in order to show all values:

CertEnd:CQIEnd:InspEnd

Upvotes: 3

Related Questions