2 Replies Latest reply: Jan 9, 2012 5:48 AM by Outi Hasila-Koskela RSS

    Default Selection in List Box of Week

      Hi,

       

      I have made a OnActiveSheet Avent Trigger, Select in Field action, for a Date field. It is working fine with the following Search String

       

      ='>=$(=Date(today()-30))<=$(=Date(today()+30))'
      

       

      In my Date List Box current day +- 30 days are selected.

       

       

       

       

      But when I am trying to do the same with a Week field I cannot get it working. Week field is made by WeekName() function in a script.

      I have tryed the following Search String:

       

      ='>=$(=WeekName(today()-30))<=$(=WeekName(today()+30))'
      

       

       

      Any ideas how should I do that?