Forum Discussion
Calculate completed operation and date difference
Hi, I'm trying to calculate Completed? column based on serial #s, operations 10-30 = completed operation based on serial #. Then calculate the date difference between completed serials (10 and 3...
Hi Greg,
To answer your question yes, the operations is noted to be completed starting with 010 Start and 030 Finish to finish.
So yes, I need to include the 010 Start to note the completion and not just add the 030. Is this possible? Thank you so much for your help.
Victor
Hi Greg,
To answer your question yes, the operations is noted to be completed starting with 010 Start and 030 Finish to finish.
So yes, I need to include the 010 Start to note the completion and not just add the 030. Is this possible? Thank you so much for your help.
Victor
Hi,
Probably need to add some flexibility as there are different text for starts (i.e., 010 Start, 010 Begin). All starts operations start with "010". Thank you.
Victor