none
Two Questions: 1) Use of ProjDateDiff formula and 2) Set baseline to earlier date RRS feed

  • Question

  • Hi,

    1) Use of ProjDateDiff formula
    I tried to use the formula ProjDateDiff(date1, date2, calendar) but it returned #Error when I tried to insert it in a new column. Please advise.

    2) Setting Project baseline
    Let's say the date is  13Mar 2013. Can I set a project baseline to an earlier date like 10th Mar 2013?

    Thank you for any help I can get.

    cheers,

    Bob

    MCT Trainer with COMAT Training Services in Singapore

    Tuesday, March 12, 2013 11:58 PM

Answers

  • Formulae can only be inserted into custom fields such as text1 or Date1.

    The date is only the date the baseline was saved (from the computer clock). It can't be changed unless you reset the computer date.


    Rod Gill

    The one and only Project VBA Book

    Rod Gill Project Management

    Wednesday, March 13, 2013 1:19 AM
    Moderator
  • Bob --
     
    Allow me to add a few thoughts in addition to those shared by my colleague, Rod Gill.  First of all, did you use the formula in a custom Duration field, such as the Duration1 field, for example?  You cannot use the formula you cited in a custom Date field, since the formula returns a duration value, not a date value.  Second, in your formula, did you actually include the name of the calendar you want the formula to use to calculate the date difference?  You have to include the name of the calendar surrounded by quotation marks.  Third, your formula will return a #Error value for every task in which the Date1 and Date2 fields contain an NA value rather than a valid date value.  Do you see valid date values for every task in both the Date1 and Date2 fields?  Please let us know and we will try to help you.
     

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Wednesday, March 13, 2013 12:08 PM
    Moderator

All replies

  • Formulae can only be inserted into custom fields such as text1 or Date1.

    The date is only the date the baseline was saved (from the computer clock). It can't be changed unless you reset the computer date.


    Rod Gill

    The one and only Project VBA Book

    Rod Gill Project Management

    Wednesday, March 13, 2013 1:19 AM
    Moderator
  • Bob --
     
    Allow me to add a few thoughts in addition to those shared by my colleague, Rod Gill.  First of all, did you use the formula in a custom Duration field, such as the Duration1 field, for example?  You cannot use the formula you cited in a custom Date field, since the formula returns a duration value, not a date value.  Second, in your formula, did you actually include the name of the calendar you want the formula to use to calculate the date difference?  You have to include the name of the calendar surrounded by quotation marks.  Third, your formula will return a #Error value for every task in which the Date1 and Date2 fields contain an NA value rather than a valid date value.  Do you see valid date values for every task in both the Date1 and Date2 fields?  Please let us know and we will try to help you.
     

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Wednesday, March 13, 2013 12:08 PM
    Moderator
  • Hi Dale,

    Thank you for your prompt response! Somehow, I managed to get it to work when I used the double quotes. That takes care of the #error.

    However, I do not have any custom calendar and when I left it out it did not show the default project Task Calendar?

    My task dates are valid.

    Once again, my sincere appreciation for you kind help.

    cheers,
    Bob

    Unable to submit screenshot as my acct needs to be verified. Will do so soon.

    Wednesday, March 13, 2013 12:49 PM
  • Thank you Rod. cheers, Bob
    Wednesday, March 13, 2013 12:49 PM
  • Bob --
     
    The Calendar part of the function is optional, not required.  If you omit the Calendar part of the function, the software defaults to the Standard calendar when it calculates the date difference.  Hope this helps.
     

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Wednesday, March 13, 2013 4:44 PM
    Moderator