Pick a date

[#1]

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.

[#2]

Thanks,

It is like getting prevoius business days.

LOad script

[giakoum]

I dont know what else you need :

giving up!

Sorry I could not help you.