Creating simple batch numbers from selected date....

  • Thread starter Thread starter Blippy
  • Start date Start date
B

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
 
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
 
Back
Top