convert the Gregorian date to Hijri date using formula (custom field)

All Replies

• Tuesday, 3 July 2012 12:21 PM

  Moderator

   

   
  

  0
  S.MALHIS --

   

  Step #7 in the web page is where you will run into problems with trying to write a formula to do this.  The only way to accomplish this would be to write a macro in the VBA programming language.  You would be better off if you would download the free Hijri Calendar Add-In for Microsoft Project, available for free download at:

   

  http://www.docstoc.com/docs/4158036/Microsoft-Project-Hijri-Calendar-Add-In

   

  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"

  • Proposed As Answer by Brian Smith - MSFTMicrosoft Employee, Moderator Monday, 9 July 2012 4:04 PM
  •  
  • Reply
  • Quote

   
• Wednesday, 4 July 2012 11:50 AM

   

   
  

  0

  Thanks alot Dale. i found that add-in before . however it will only work in MS project 2010 my problem is how to show the Hijri date over the PWA. anyway thanks and i agree with you that step#7 needs VBA development.

  • Reply
  • Quote

   
• Wednesday, 4 July 2012 1:55 PM

  Moderator

   

   
  

  0
  S.MALHIS --

   

  You are more than welcome for the help, my friend!  :)

  ---

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

  • Reply
  • Quote

   
• Tuesday, 17 July 2012 6:20 AM

   

   
  

  0

  Dale,

  I am glad to find a recent post about this, however using that link and others around the web only providesthe word document and not the actually download containing the two files needed for the add-in.  The email address contained in the document for microsoft doesn't work as well.  Do you know a location that has the add-in or have the files?

  Thank you

  
  Scott

  • Reply
  • Quote

   
• Tuesday, 17 July 2012 12:54 PM

  Moderator

   

   
  

  1
  Scott --

   

  I regret to inform you that I can confirm everything you say.  I cannot find the Hijri calendar add-in anywhere on the Internet, including in the Microsoft download center.  It does not seem to be available for download any longer.  Sorry.

  ---

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

  • Reply
  • Quote

   
• Wednesday, 18 July 2012 5:34 AM

   

   
  

  0

  Dale,

  Thank you,  I noticed in a couple of forums  that you can change the calendar type under options and Display,  however my version of MS Project 2010 only includes the Gregorian calendar and to be honest I would like both set of dates like the Hijri add-on showed in the word document, our company works in Gregorian but a project we are focused on requires Hijri dates as well.  I guess what I will do is create a text field in my project and when we are done with the updates export the dates to excel,  convert to Hijri and then copy-paste back into project.  I really appreciate you looking or confirming that the add-in isn't available anymore, hate to use the forums to just ask "can you tell where the download is."

  Thank you again

  
  Scott

  • Reply
  • Quote

   
• Wednesday, 18 July 2012 12:26 PM

  Moderator

   

   
  

  0
  Scott --

   

  You are more than welcome for the help, my friend!  :)

   

  ---

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

  • Reply
  • Quote