Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
> 
Need help with a formula for a calendar field

Proposed Need help with a formula for a calendar field

  • Friday, 30 December 2011 2:36 PM
     
     
    Sign In to Vote
    0

    Hello,

    Does anyone know what the formula is for a calendar field to display today's date? For example, "Start Date" calendar field to displays today's date when a new project is created?

    thanks

    • Edited by pawel850 Friday, 30 December 2011 6:01 PM
    •  
     

All Replies

  • Friday, 30 December 2011 7:20 PM
    Moderator
     
     
    Sign In to Vote
    0

    pawel850 --

    In a formula, you use the function Now() to capture the current date.  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"

     
  • Friday, 30 December 2011 9:10 PM
     
     
    Sign In to Vote
    0
    If I use the formula then the field becomes not editable when it's added to the PDP and there is no calendar icon next to it.
     
  • Saturday, 31 December 2011 5:05 PM
    Moderator
     
     Proposed
    Sign In to Vote
    0

    pawel850 --

    If you want the field to be editable, then you CANNOT use a formula in it. Instead, create a custom Date field without a formula.  However, the field will not pick up the current date, and I do not know any way around this limitation.  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"