Morning,
One query that i need to run contains, amongst other things, two date fields. These are to do with training. First one is DateStarted and the other DateCompleted.
I need to run a query to check all the training occurrences for null DateCompleted but only where there IS a value (any value) for DateStarted.
This is because other calculations in the DB work off DateCompleted field, such as invoicing and resourcing.
Reason: Call it a user admin check to see if any entries are missing for DateCompleted where they should have been filled in. Blank entries are fine in DateCompleted since some training courses (although listed as only 10 days long) can be stretched out depending on staff and trainer availability so can actually stretch over 4/5 weeks. Blank entries in DateStarted also occur since training is booked, but only estimated when it comes to a dtart date.
One query that i need to run contains, amongst other things, two date fields. These are to do with training. First one is DateStarted and the other DateCompleted.
I need to run a query to check all the training occurrences for null DateCompleted but only where there IS a value (any value) for DateStarted.
This is because other calculations in the DB work off DateCompleted field, such as invoicing and resourcing.
Reason: Call it a user admin check to see if any entries are missing for DateCompleted where they should have been filled in. Blank entries are fine in DateCompleted since some training courses (although listed as only 10 days long) can be stretched out depending on staff and trainer availability so can actually stretch over 4/5 weeks. Blank entries in DateStarted also occur since training is booked, but only estimated when it comes to a dtart date.
