$Revisions in Selection Formula of view or db Search

HCL Domino Domino Forum
1

Hi,

Is it possible to use @Date(@Subset($Revisions;1)) = “22/05/2008”?

Have tried even with @Date (“22/05/2008”).

Have tried:

sF = “Form = ‘Test’ & @Date(@Subset($Revisions;1)) = ‘22/05/2008’”

but it gives me no info, however there are documents with the $Revision date above. I have created a column with the formula → @Date(@Subset($Revisions;1)) and it gives me the correct values of 22/05/2008.

Is there a restriction on using $Revisions in the selection formula? I’ve even tried get document by key and then looking for the last modified date, using Evaluate and the Subset of $Revisions, but it gives blank info.

I’ve tried using doc.LastModified, still no data.

Any ideas?

Thanks

2

Subject: You’re not comparing apples to apples here…

I believe your formula should read…

@Date(@Subset($Revisions;1)) = [22/05/2008]

Use square braces around dates.

3

Subject: RE: You’re not comparing apples to apples here…

Hi Terry!

Thank you!!! It is amazing how when a person miss something small like that confuses the hell out of a person.

Thanks again.