Hello everybody,

I have an issue with a code. I'm don't know how to start this.

Here is my problem:
Column 2 of my MSFlexgrid = store number. Ex: 1009,1010 etc.

In column 20 of my MSFlexgrid = Delivery day. Ex: Sun, Mon, Tue......,

Now if store 1009 have multiple delivery days ex:


The logic will have to be that way:
If the the holiday entered in the Form4.day_ferier (Combo Box) is "Mon"
Then it will calculate how many day it will have until the next delivery.

In that case,Monday to Friday = 4 days.

Then it will calculate how many days there was from the previous delivery. Friday to Monday = 3 days.

So since Monday to Friday is bigger that Friday to monday, then the results will be Monday +1. So Tuesday.

If the result would of been less, then it would of been Monday - 1. So Sunday.

If it would of been equal, by default, it would be Monday - 1.

Would it be easier if I change Sun by "1", Mon by "2", Tue by "3" and so on...

Thank you so much for your help.

This post has been edited by wilder: 1 Nov, 2009 - 02:54 PM

Need to show code for analysis.

What i did for now is to change the day with a number:




and what it should do is something like this:

mon - fri = 4
fri-mon =3

explain a little bit and show your whole grid is hat your grid holds the weekday number if yes then it is simple else store that number also
and hide it now it's so simpler to you

may i know why should you do this
to me there is some logic miss

Here is a part of my grid to show you more. I took of the extra data since there's a lot.

This data comes from another program. so I can modify it except for changing days.

Since I will use the code only to modify week with holiday, it's not a weekly tool but could save a lot of time since I have thousands of line in that grid.

I just need to change the holiday.

So if the store in the grid have 2 days of delivery, only the holiday will be change.

When you say:
Mon - Fri = 4
Fri-Mon =3

If I take the example of the picture attached to this post, 1503. As you can see, he's got a delivery on Monday, and on Thursday. If the holiday, or the day OFF is on Monday, it will have to change that day.

The logic is that the holiday Monday, will be forwarded to Tuesday or it will be move to Sunday.

How do we determine that?

It will calculate the number of day between Monday to the next day and also Monday to the last delivery just before.

So in both days for store 1503, We only have Monday and Thursday.

So Monday to Thursday = 3 days and Thursday to Monday = 4 days.

Since Monday to Thursday < Thursday to Monday then I will move Monday backward -1. So Sunday.

If I would of done the opposite way, so Monday + 1, Tuesday to Thursday = 2 days and Thursday to Tuesday = 5 days. So to long between deliveries.

how did you find whether a day is holiday did you have any other table

according to your statement alternate rows are the deliveryday
but note the shop no 1506 it has only wednesday how could you determine the delivery date

ok listen now add a column in this grid and hide it, for each row in the grid add the corresponding day no

in a for loop check whether the day is holiday then do your logic there if you can post this form's code here surely, i will help you

So i could add a column:


But how can I manage to add the corresponding day no?

All day are this format: Sun, Mon, Tue ....... Mon, Tue .......

But i like your idea!

best regards

it's simple use a for loop and use a select statement to do this