Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
PFA,
Table:
LOAD * INLINE [
Token Num, OrderDate, Invoice Date
100, 1/1/2014, 1/5/2014
101, 1/9/2014, 1/15/2014
102, 1/13/2014, 1/23/2014
103, 1/22/2014, 1/31/2014
104, 1/25/2014, 2/5/2014
105, 2/6/2014, 2/10/2014
106, 2/12/2014, 2/14/2014
107, 2/15/2014, 2/22/2014
108, 2/23/2014, 2/27/2014
109, 3/1/2014, 3/5/2014
110, 3/10/2014, 3/15/2014
110, 3/10/2014, 3/15/2014
];
Holiday List:
Load * Inline
[Date, Holiday List
7/1/2014, Guru Govind Singh Jayanti
14/1/2014, Pongal
26/1/2014, Republic Day
31/1/2014, Chinese New Year];
Here calculating Sunday also...
Example:
OrderDate InvoiceDate Count_of_Holidays
1/1/2014 1/8/2014 3 (1 sat, 1 sun and 1 holiday total=3)
1/27/2014 2/1/2014 1 (1 holiday)
Hope you Understand................
Thanks in Advance...........
Please check
Hi Clever,
But here not all Saturday's (1st and 3rd Saturday's holiday and 2nd, 4th and 5th Sat's working days )
please can you write scripting level............
Like This ?
PFA
Hi,
Thanks for Helping..
I got it...............