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?
