Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
I have a typical issue and couldn't find any post in the community already answering this:
I need to create a calendar based on selections done in 3 Listboxes --> Code, Year and Month (this has a list of working and non-working days in the form of 0's and 1's).
An example:
Code |Year |Jan |Feb |Mar.................
01 |2014 |011....111|00111...111|0011...11 ..............
01 |2015 |010...110|011111..0 |01111..11..................
.
.
.
02.................................
.
.
.
03...................................
.
.
.
04.......................................
I have loaded this table of data(as above) pertaining to these fields--Code,Year and all the months as Fields (Jan,Feb ...Dec). Every month having the values in the form of 0's and 1's representing non working days(0's) and working days(1's). I need to create a table as an output which can show up by clicking a button (after selection made from Code,Year) and must contain
Code | Year | Month | Date | Working/Non-Working Day |
---|---|---|---|---|
01 | 2014 | 01 | 01/01/2015 | 0 |
01 | 2014 | 01 | 02/01/2015 | 1 |
01 | 2014 | 01 | 03/01/2015 | 1 |
I have framed the question in the best of language I could hope to get some solution from the experts.
Thanks
Would you able to provide sample data which demonstrates the output.
Hi Anil,
This is the output required:
Code | Year | Month | Date | Working/Non-Working Day |
---|---|---|---|---|
01 | 2014 | 01 | 01/01/2015 | 0 |
01 | 2014 | 01 | 02/01/2015 | 1 |
01 | 2014 | 01 | 03/01/2015 | 1 |