Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to change the start & end dates as follows:
ID | StartDate | EndDate | Hours |
---|---|---|---|
1 | 6/29/12 | 9/5/12 | 100 |
2 | 7/4/12 | 12/8/12 | 50 |
ID | StartDate | EndDate | Hours |
---|---|---|---|
1 | 6/29/12 | 6/30/12 | 100 |
1 | 7/1/12 | 7/31/12 | 100 |
1 | 8/1/12 | 8/31/12 | 100 |
1 | 9/1/12 | 9/5/12 | 100 |
2 | 7/4/12 | 7/31/12 | 50 |
2 | 8/1/12 | 8/31/12 | 50 |
2 | 9/1/12 | 9/30/12 | 50 |
2 | 10/1/12 | 10/31/12 | 50 |
2 | 11/1/12 | 11/30/12 | 50 |
2 | 12/1/12 | 12/8/12 | 50 |
I'm unable to break the months apart into individual months. Any help is greatly appreciated!
Thanks!
Hope ite helps!
Thank you At titude! for your reply. However, I am sorry I wasnt clear in my question above. The first table is my data (there are several hundreds of rows in that manner)
The second table is the way I want the output displayed.
Is this possible? Thanks
Not sure whether it is possible! If you can attach your application we can help you out...
Hi, Please see the QV application attached. The data has groups of months and I need to pull individual months out. Is there a way to do this?
The output needs to look like:
ID | StartDt | EndDt | Hours |
---|---|---|---|
1 | 6/29/12 | 6/30/12 | 100 |
1 | 7/1/12 | 7/31/12 | 100 |
1 | 8/1/12 | 8/31/12 | 100 |
1 | 9/1/12 | 9/5/12 | 100 |
2 | 7/4/12 | 7/31/12 | 50 |
2 | 8/1/12 | 8/31/12 | 50 |
2 | 9/1/12 | 9/30/12 | 50 |
2 | 10/1/12 | 10/31/12 | 50 |
2 | 11/1/12 | 11/30/12 | 50 |
2 | 12/1/12 | 12/8/12 | 50 |
Thanks in advance!