Discussion on:

2
Comments

Join the conversation!

Follow via:
RSS
Email Alert
0 Votes
+ -
Late Starts
alp0091 11th Jul
This is excellent. How could a script account for late starts. The query would need focus on the Actual Start missing prior to the schedule date but I don't know what that would look like in VBA.
0 Votes
+ -
I would define a late start where the ActualStart is > Baseline Start, so you would adjust the IF statement:

If t.ActualStart > t.BaselineStart Then

(Treat that line as pseudo code as I'm typing it..vs building it into the script)

If you didn't want to use VBA, you could also do a custom highlight filter

Andy
Keyboard Shortcuts:
Prev
Next
Toggle
Join the conversation
Formatting +
BB Codes - Note: HTML is not supported in forums
  • [b] Bold [/b]
  • [i] Italic [/i]
  • [u] Underline [/u]
  • [s] Strikethrough [/s]
  • [q] "Quote" [/q]
  • [ol][*] 1. Ordered List [/ol]
  • [ul][*] · Unordered List [/ul]
  • [pre] Preformat [/pre]
  • [quote] "Blockquote" [/quote]

Join the TechRepublic Community and join the conversation! Signing-up is free and quick, Do it now, we want to hear your opinion.