How to do that?

[#1]

Dear all, I have 2 tables first one with data / hour and code and second one with code hour and days and I want to do the next

Table 1:

Date Code

18/03/2010 18:45 25

Second Table

Monday Tuesday Wednesday Thursday Friday Saturday Sunday Hour Days Code

0 0 1 1 1 0 0 15:00 3 25

I want to do the next one:

Get day name of the date

See for code

See on table 2 if day=1

if day=1 then check if hour >= Hour Date

If Hour>Hour(Date) - Then get Days

and calculate New date as date + Days (if days are saturday or sunday sum 1 for each one)

else

go to the next day and chek if = 1 if not eq 1 continue with next day (loop) and Then get days

and calculate New date as date + Days (if days are saturday or sunday sum 1 for each one)

if day = 0 goto next day (cyclic) till day = 1

And then calculate new date.

Can someone help me?

[#2]

Hi Jordi,

I would like to help you. Pls let me know the criteria / conditions in detail and what should be your output.

Regards

Rajesh