0 Replies Latest reply: Oct 5, 2011 5:42 AM by Kenneth Gevaert RSS

    Bookmarks containing a formula for period selections

      Hi,

       

      I have a field (date_YYYYMM) which is formatted as YYYYMM.

      My end users want to see the past 3 months standard selected when opening the document. I want to set this up via a bookmark (as they also want other standard selections on opening).

      Therefore I built this formula:

      >= date(addmonths(date#(max(date_YYYYMM),'YYYYMM'),-3),'YYYYMM') and < date(addmonths(date#(max(date_YYYYMM),'YYYYMM'),0),'YYYYMM').

       

       

       

       

       

       

       

       

       

       

      I have put this in a variable "testperiod"

      Now after using advanced search in a selection box,and referring to this variable, all periods have been selected. Which is of course not what I want.

      Can anybody help?

      many thanks,

      Kenneth