Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gogglebox

    Formula for comparing two finish dates

    Thanks Julie for all your help.[bigsmile]
  2. gogglebox

    Formula for comparing two finish dates

    Hi Julie, The file contains restricted information so I can't send it to you unfortunately. How would I amend your formula 'IIf(IsDate([Finish])=No,"No Finish",IIf([Finish1]=ProjDateValue("NA"),"No Finish1",IIf([%...
  3. gogglebox

    Formula for comparing two finish dates

    Hi Julie I'm using 2010 :) I would be interested to know; - Even though it can't be shown, in the background, does project schedule in seconds or are minutes the lowest measurement? - Can the formula be amended so that it only compares between two dates and ignores minutes/seconds? Your help...
  4. gogglebox

    Formula for comparing two finish dates

    Hi Julie, I have pressed f9 and makes no difference. I know you can't view seconds in project but wondered if project calculates the difference at that level which could be the reason why I'm getting the unexpected results. I'm therefore asking can the code be amended so that it only calculates...
  5. gogglebox

    Formula for comparing two finish dates

    Hi Julie, I have a problem with the results of this formula. I copy all the task dates from finish to finish 1 and there are exactly the same right down to the minutes. However, the results I get are either 1, 2 or 3 and should be only 3. Any thoughts why? Is there a way this formula only...
  6. gogglebox

    Formula for comparing two finish dates

    Sorry Julie I don't know why I included 'date' must have had a bad day in the office. Anyway, your formula works great. Thank you for your help.
  7. gogglebox

    Please help- going crazy

    Hi Senorita, In my view, a 4000 line schedule is far to big to manage properly. I would be looking how the schedule could be consolidated or broken down into smaller more manageable chunks. Anyway, to see the predecessors and/or successors you need to insert two columns. Right click on any...
  8. gogglebox

    Formula for comparing two finish dates

    I have tried many variants using the following formulas as the basis but can't get the finish date is equal to finish date to work. Any suggestions? IIf([% Complete]=100,"0",IIf([Finish date]-[Finish1 date]>10,"1",IIf([Finish date ]-[Finish1 date ]>1,"2","3"))) switch([%...
  9. gogglebox

    Formula for comparing two finish dates

    Hi All, I'm new to the forum and don't know if anyone could help. I need a formula to be able compare the movement of two finish dates. For example; If task = 100% Complete then 0 If finish date is greater than finish1 date then 1 If finish date is less than finish1 date then 2 If finish...
  10. gogglebox

    A Formula Request

    Hi SkipVought, Apologies, I was trying to keep the same theme going. I will post a new thread. Thanks Gogglebox
  11. gogglebox

    A Formula Request

    Hi Julie, I'm new to the forum and don't know if you could help. I have a similar request to Planner18. I need a formula to be able compare the movement of two finish dates. For example; If task = 100% Complete then 0 If finish date is greater than finish1 date then 1 If finish date is less...

Part and Inventory Search

Back
Top