<div>
Thanx a bunch guys<br />
<br />
<br />
I am working within an existing db and have been asked to manipulate some of the views. I am trying to stick within their framework<br />
<br />
MY solution was to add a field to the form and do the calculation there and then pull it into the view<br />
<br />
I think that satisfies allrequirements as wellas any concerns<br />
<br />
Thanx again<br />
<br />
James
</div>


Thanx a bunch guys


I am working within an existing db and have been asked to manipulate some of the views. I am trying to stick within their framework

MY solution was to add a field to the form and do the calculation there and then pull it into the view

I think that satisfies allrequirements as wellas any concerns

Thanx again

James

<div>
<div class="content wysiwyg-content">
Hi guys<br />
<br />
This is a current form formula for a view. It is used by an scheduled agent which runs at 1:00 am<br />
<br />
SELECT Form=&quot;WebRegistration&quot;<br />
&quot;Registration&quot; &amp;&nbsp;SStatus=&quot;Enrolled&quot; &amp;&nbsp;@TextToTime(SessionDateDT)<wbr />=@Tomorrow<wbr /><br />
<br />
What I would like to do is have the view show the documents that are 2 days before the meeting, not one day as shown.<br />
<br />
I understand the logic involves subtraction, I have had no luck with trying to get a date 2 days prior to SessionDateDT<br />
<br />
Any help appreciated<br />
<br />

</div>
</div>


Hi guys

This is a current form formula for a view. It is used by an scheduled agent which runs at 1:00 am

SELECT Form="WebRegistration"
"Registration" & SStatus="Enrolled" & @TextToTime(SessionDateDT)=@Tomorrow

What I would like to do is have the view show the documents that are 2 days before the meeting, not one day as shown.

I understand the logic involves subtraction, I have had no luck with trying to get a date 2 days prior to SessionDateDT

Any help appreciated



Help with dates in a view selection

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.