11 Replies Latest reply: Aug 9, 2012 12:39 PM by ioannis giakoumakis RSS

    Pick a date

      Hi All,

      Hope all doing well.

       

      I am stuck and I need help.

       

      1. I have calendar and i want to pick a previous day of the row i am processing. If i am processing 07/05/2012, i want to pick 07/03/2012 as previous date because 07/04/2012 is Holiday. If i am processing. I want to skip holidays and week ends. How can I achieve that.

       

      2. I want to get the diff of sum(today's amt - previous day amt) in chart excluding holidays and weekends. I hope it can be dome by set analysis

       

      Thank you in advance.