kmartin
May 15th, 2006, 04:58 PM
I have two DateTime fields. One specifies an open time, the other specifies a close time. I wish to create a string array of all the months (either names or numbers) between and including the open and close times. For instance...
If open = 4/5/05 14:53:23; closed = 7/24/05 02:01:59
==> Then I want to return ["4", "5", "6", "7"]
The trick is that this must hold true for cases when the range wraps --
If open = 12/10/04 06:44:47; closed = 2/26/05 09:23:48
==> Then I want to return ["12","1","2"]
Does anybody have any insight? I've been working on this for a while now and VB is just not my thing, so I really am digging myself into a hole.
Thank you all in advance.
If open = 4/5/05 14:53:23; closed = 7/24/05 02:01:59
==> Then I want to return ["4", "5", "6", "7"]
The trick is that this must hold true for cases when the range wraps --
If open = 12/10/04 06:44:47; closed = 2/26/05 09:23:48
==> Then I want to return ["12","1","2"]
Does anybody have any insight? I've been working on this for a while now and VB is just not my thing, so I really am digging myself into a hole.
Thank you all in advance.