Creating simple batch numbers from selected date....

[Blippy]

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

 

[Cor Ligthert [MVP]]

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/d...cpref/html/frlrfsystemdayofweekclasstopic.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

 

[Ken Tucker [MVP]]

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/default.asp?url=/library/en-us/vblr7/html/vafctdatediff.asp

Ken
----------------------------
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