Em Andamento

Write VB6 Date Function to replace SQL lookup

We are currently working with a delivery schedule that we keep in a SQL table. We would like to eliminate this table & calculate the values in real time.

The table contains three fields: Date, Day of week, week number. Day of week is coded as follows: M=Monday, T=Tuesday,W=Wednesday,H=Thirsday,F=Friday.

Saturdays & Sundays must always be skipped. Holidays are not part of this so every day that is Monday - Friday is a valid day.

There is a six week cycle, so the week number will always be one of the following: 1,2,3,4,5,6.......(repeating)

An example of the entires are below:

11/23/2009? M? 1

? 11/24/2009? T? 1

? 11/25/2009? W? 1

? 11/26/2009? H? 1

? 11/27/2009? F? 1

? 11/30/2009? M? 2

? 12/1/2009? T? 2

? 12/2/2009? W? 2

? 12/3/2009? H? 2

? 12/4/2009? F? 2

? 12/7/2009? M? 3

? 12/8/2009? T? 3

? 12/9/2009? W? 3

? 12/10/2009? H? 3

? 12/11/2009? F? 3

? 12/14/2009? M? 4

? 12/15/2009? T? 4

? 12/16/2009? W? 4

? 12/17/2009? H? 4

? 12/18/2009? F? 4

? 12/21/2009? M? 5

? 12/22/2009? T? 5

? 12/23/2009? W? 5

? 12/24/2009? H? 5

? 12/25/2009? F? 5

? 12/28/2009? M? 6

? 12/29/2009? T? 6

? 12/30/2009? W? 6

? 12/31/2009? H? 6

? 1/1/2010? F? 6

? 1/4/2010? M? 1

? 1/5/2010? T? 1

? 1/6/2010? W? 1

? 1/7/2010? H? 1

? 1/8/2010? F? 1

? 1/11/2010? M? 2

? 1/12/2010? T? 2

? 1/13/2010? W? 2

? 1/14/2010? H? 2

? 1/15/2010? F? 2

The function needs to work in one of two ways:

Accounting for the current date (Now);

This function will be passed the day of week code and the week number & must return the appropriate calander date.

This function will be passed the day of week code & must reurn the next date which is for that day of the week.

In both cases, the date returned must be greater than or equal to Now(). Date in the past are no longer valid.

## Deliverables

Sorry - Visual Basic 6.0 ONLY

Habilidades: Engenharia, Microsoft, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software, Visual Basic, Área de trabalho do Windows

Ver mais: write every day, number function, function number, calculate and write, accounting cycle, t-sql with, t-sql in, visual basic vb6, t-sql;, sundays, date, always write, example sql vb6, php function vb6, visual basic week, sql accounting, php lookup, delivery date, day number week, visual schedule, visual basic six, date monday, php function write, function time, Accounting part time

Acerca do Empregador:
( 38 comentários ) United States

ID do Projeto: #3021846

Premiar a:

schandraram

See private message.

$25.5 USD em 14 dias
(167 Avaliações)
6.9

24 freelancers estão ofertando em média $206 para este trabalho

gribfritz

See private message.

$21.25 USD in 14 dias
(487 Comentários)
7.6
hwanghendra

See private message.

$38.25 USD in 14 dias
(452 Comentários)
6.9
abvdb

See private message.

$21.25 USD in 14 dias
(97 Comentários)
6.0
NeoNoXtraOrdnry

See private message.

$17 USD in 14 dias
(86 Comentários)
5.7
idealsolutionvw

See private message.

$17 USD in 14 dias
(106 Comentários)
5.5
baburam

See private message.

$17 USD in 14 dias
(99 Comentários)
5.2
Lotusdeveloper

See private message.

$14.45 USD in 14 dias
(80 Comentários)
5.2
svyatonik

See private message.

$42.5 USD in 14 dias
(20 Comentários)
4.5
ahetel

See private message.

$17 USD in 14 dias
(29 Comentários)
4.4
iservi

See private message.

$4250 USD in 14 dias
(7 Comentários)
3.9
skujuira

See private message.

$68 USD in 14 dias
(9 Comentários)
4.1
tabakerka

See private message.

$25.5 USD in 14 dias
(8 Comentários)
3.8
sdcoder

See private message.

$21.25 USD in 14 dias
(5 Comentários)
3.6
huntergreen

See private message.

$51 USD in 14 dias
(4 Comentários)
3.4
kanhashriinc

See private message.

$22.95 USD in 14 dias
(9 Comentários)
2.9
vb5prgrmr

See private message.

$42.5 USD in 14 dias
(1 Comentário)
2.5
veenuvw

See private message.

$21.25 USD in 14 dias
(17 Comentários)
2.3
yates

See private message.

$85 USD in 14 dias
(2 Comentários)
1.6
SecuredSolutions

See private message.

$85 USD in 14 dias
(1 Comentário)
0.8
codingpal

See private message.

$6.8 USD in 14 dias
(1 Comentário)
0.0