I want to create a small look up program that searches for a certain
date and the batch number that is represented by that day. For instance
if i wanted to find the batch for 20/08/05 i would choose that date and
then the program would tell me that it was batch 125. The batch number
are incremented by 1 everyday apart from SUNDAYS.

Is there an easy way that I can do this??? Here are some demo batch
numbers to show it all works...


Sat 20/08/05 batch num = 125
Mon 22/08/05 batch num = 126
Tue 23/08/05 batch num = 127
Wed 24/08/05 batch num = 128
Thur 25/08/05 batch num = 129
Fri 26/08/05 batch num = 130
Sat 27/08/05 batch num = 131
Mond 29/08/05 batch num = 132

Thanks in advance...

Scott boy

Blippy,

Probably you can do this mathametical. I would however create an arraylist
of DateTimes starting at your first date, than remove by looping backwards
through this array all sundays.
http://msdn.microsoft.com/library/de...classtopic.asp

And than I have in my idea a table with all batch numbers, where the index
is the batch number.

However not tested.

Cor

Hi,

In addition to Cor's comments you could use the datediff function to
determine how manys days the date is from the start date.

http://msdn.microsoft.com/library/de...ctdatediff.asp

Ken
----------------------------
"Blippy" <(E-Mail Removed)> wrote in message
news:txfOe.180$(E-Mail Removed)...
I want to create a small look up program that searches for a certain
date and the batch number that is represented by that day. For instance
if i wanted to find the batch for 20/08/05 i would choose that date and
then the program would tell me that it was batch 125. The batch number
are incremented by 1 everyday apart from SUNDAYS.

Is there an easy way that I can do this??? Here are some demo batch
numbers to show it all works...


Sat 20/08/05 batch num = 125
Mon 22/08/05 batch num = 126
Tue 23/08/05 batch num = 127
Wed 24/08/05 batch num = 128
Thur 25/08/05 batch num = 129
Fri 26/08/05 batch num = 130
Sat 27/08/05 batch num = 131
Mond 29/08/05 batch num = 132

Thanks in advance...

Scott boy