Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
For every "TICKET NUMBER" there comes one "CREATION DATE" and "ENGINEER COMPLETED DATE".
I want to Calculate the Holidays Count falling between these 2 Dates for unique TICKET NUMBERS.
EXAMPLE : FOR AUGUST MONTH :
ORGANIZATION NAME OF ENGINEER :
1) LEVEL IV DELHI = 4 Holidays (09/08/13,15/08/13,20/08/13,28/08/13)
2) ASF PATNA = 2 Holidays (09/08/13,15/08/13)
3 ASF BHUBANESHWAR = 2 Holidays (09/08/13,15/08/13)
If HOLIDAY Dates falling between the Unique "TICKET NUMBER"
"CREATION DATE" and "ENGINEER COMPLETED DATE" then Show its Holiday Count.
See attached qvw
Perfect Sir. Thank You very much.