I'm trying to draw a vertical line on a chart at a date sometime in the future say 30 days for example. The problem I'm running into is that if the date I try to draw the line falls on a holiday or weekend the line is not drawn and I need to draw the line on the nearest day.
Is there an easy way to tell if a date sometime in the future will be on the chart? I'm thinking there should be because if I drag the chart to the left and hover my mouse over the chart I can see that certain dates are missing. I know I can easily write a function to tell if the day is a weekend but that doesn't help for holidays and I really don't want to have to make a list of holidays since that would require manual updates. I'm really hoping to avoid that with some built-in function or something...
I was thinking I could do a DrawObjects.Count before and after I draw the line and if they're equal then assume the line didn't draw but I haven't tried that yet so I'm not sure if it would work and I'm really hoping there's a more elegant solution than that.
Is there an easy way to tell if a date sometime in the future will be on the chart? I'm thinking there should be because if I drag the chart to the left and hover my mouse over the chart I can see that certain dates are missing. I know I can easily write a function to tell if the day is a weekend but that doesn't help for holidays and I really don't want to have to make a list of holidays since that would require manual updates. I'm really hoping to avoid that with some built-in function or something...
I was thinking I could do a DrawObjects.Count before and after I draw the line and if they're equal then assume the line didn't draw but I haven't tried that yet so I'm not sure if it would work and I'm really hoping there's a more elegant solution than that.
Comment