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

    How to use Monthend()

    nassim kasdali



      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 ?!