AboutPaski K. Paskaradevan Expertise I have 3 + years in Lotus Notes application development. I am a CLP R5 Application Development. I can answer any question pertaining to application development.
Experience R5 CLP. In addition, I have a bachelors degree in Engineering and a MBA.
Question I am writing a formula which return documents from database
and looks like this:
(@Contains(Receiver; "some inf") & (@Contains(Status; "some inf") | @Contains(Status; "some inf") | @Contains(Status; "some inf"))&(TRICKY PART))
TRICKY PART should be some kind a function or something like that which compare two dates date1 and date2.
I need to return true if first date is bigger then seccond.
Actualy i need to compare LastModified to another date if LastModified is bigger or equal return @True.
Thanks.
Answer Hi,
There are two ways you can do this.
One is straight comparison of two dates using > or < operator.
So the trickypart will look like DateA >= DateB
Another is to subtract one date from another.
DateA-DateB will give you a number. So, if you want to select documents where DateA is greater than DateB, then the Trickypart will look like DateA-DateB >= 0
