<div>
But don't EVER do this in a view column, for it will make the view unnecessarily slow. It's better to add a field that does this computation when the document is saved.
</div>


But don't EVER do this in a view column, for it will make the view unnecessarily slow. It's better to add a field that does this computation when the document is saved.

<div>
sjef_bosman , What does the first line mean?<br />
<br />
Cos the dates in the 6 fields could be in 2008 or so!
</div>


sjef_bosman , What does the first line mean?

Cos the dates in the 6 fields could be in 2008 or so!

<div>
and... &nbsp;What should I do if the database already have records in it?
</div>


and...  What should I do if the database already have records in it?

<div>
Use @Sort if you are using R6<br />
<br />
eg:<br />
<br />
list := @trim(f1:f2:f3:f4:f5:f6);<br />
Sort(list; [Descending])<br />
<br />
~Hemanth
</div>


Use @Sort if you are using R6

eg:

list := @trim(f1:f2:f3:f4:f5:f6);
Sort(list; [Descending])

~Hemanth

<div>
Ok, sjef_bosman &nbsp;solution works fine, thank you!
</div>


Ok, sjef_bosman  solution works fine, thank you!

<div>
You CAN get OK performance out of the @Today by using an odl textttime of &quot;Today&quot; trick.
</div>


You CAN get OK performance out of the @Today by using an odl textttime of "Today" trick.

<div>
The first line creates a vraiable with a date 100 years from now, assuming you're not going over it. Astronomers do...
</div>


The first line creates a vraiable with a date 100 years from now, assuming you're not going over it. Astronomers do...

<div>
<div class="content wysiwyg-content">
This question is based on Q_21139033<br />
<br />
Let's say I have 6 different &quot;date/time&quot; fields.<br />
<br />
Some of them could be left blank.<br />
<br />
In a view, I'd like a specific column to show the earliest date among the 6 fields...<br />
<br />
So, is there a way to do a Switch/case thing in Lotus Notes?? &nbsp;Or should I make a big IF statement?
</div>
</div>


This question is based on Q_21139033

Let's say I have 6 different "date/time" fields.

Some of them could be left blank.

In a view, I'd like a specific column to show the earliest date among the 6 fields...

So, is there a way to do a Switch/case thing in Lotus Notes??  Or should I make a big IF statement?

Switch/case instead of If

Lotus Software produced the Lotus 1-2-3 spreadsheet program, and later developed Lotus Notes, a groupware and email system. Following its acquisition by IBM, the Notes and Domino client/server collaborative platform were expanded to include functions such as email, calendars, to-do lists, contacts management, teamrooms, discussion forums, file sharing, microblogging, instant messaging, blogs, and user directories. IBM also release SmartSuite, a comprehensive office suite, and followed that with Symphony, unrelated to the Lotus suite of the same name.