10 Replies Latest reply: Oct 2, 2012 6:02 AM by nassim kasdali RSS

    How to use Monthend()

      Hi,

       

      i creted in my script two flags,

       

      the first :

       

      if(CalendarDate=MonthStart(CalendarDate),1,0) as Start_Flag   //in the aim to know if is the first day of the month
      

       

       

      and a second :

      if(CalendarDate=MonthEnd(CalendarDate),1,0) as end_Flag   //to know if is the last day in the month
      

       

       

      but the second doesn't work !! it gives me 0 to all fields.

       

      can you help me ?!