![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
This program is nine and ninety kinds of hell right now.
1. It's two tables full of dates and data.
2. I have to merge the two into a single one, with dates.
Sounds easy? It's not!
So the Table 2 record starts in the middle of Table 1? Fine. Where does it end? Does it end before record 1 finishes? Does it end right when record 1 finishes? does it end after record 1 finishes? How do I keep track that I"m in Record 2 when I close Record 1 (and it's change of data), and then make sure that I save record 2 when it closes in the middle of the next Record 1?
I've looped and put markers down and compared dates and recorded variables and I swear to God, I am going NUTS.
And, of course, Bigwig #1 (not in my line) has decided that THIS MUST BE DONE THIS WEEK. Like I hadn't had it done for a month before anyone got back to me about it. *sigh*
1. It's two tables full of dates and data.
2. I have to merge the two into a single one, with dates.
Sounds easy? It's not!
So the Table 2 record starts in the middle of Table 1? Fine. Where does it end? Does it end before record 1 finishes? Does it end right when record 1 finishes? does it end after record 1 finishes? How do I keep track that I"m in Record 2 when I close Record 1 (and it's change of data), and then make sure that I save record 2 when it closes in the middle of the next Record 1?
I've looped and put markers down and compared dates and recorded variables and I swear to God, I am going NUTS.
And, of course, Bigwig #1 (not in my line) has decided that THIS MUST BE DONE THIS WEEK. Like I hadn't had it done for a month before anyone got back to me about it. *sigh*
Tags: