Where is ProjDateDiff????

[dgmoore]

All,

I work with a number of different installations of MSProject, including
Prj 2000 SR-1 and Prj Standard 2003. The references are set
appropriately in each (MSPRJ9.OLB for Prj 2K, OFFICE11\MSPRJ.OLB for
Prj 2003). Any time I try to call ProjDateDiff() using any of these
installations I get a 'function not defined' error.

Can anybody tell me where ProjDateDiff is located or suggest why my Prj
installs can't seem to find it?

Thanks
Dave
[david dot moore at ngc dot com]

 

[Jan De Messemaeker]

Hi,

Your VBA doesn't find it because in VBA it does not exist, as simple as
that.
Use Application.datedifference
HTH

 

[dgmoore]

Thanks, Jan - that did the trick. Just out of curiosity, if
ProjDateDiff does not exist in VBA, where are all of the folks who
write about it call it from?

Cheers
Dave

Hi,

Your VBA doesn't find it because in VBA it does not exist, as simple as
that.
Use Application.datedifference
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620

All,

I work with a number of different installations of MSProject, including
Prj 2000 SR-1 and Prj Standard 2003. The references are set
appropriately in each (MSPRJ9.OLB for Prj 2K, OFFICE11\MSPRJ.OLB for
Prj 2003). Any time I try to call ProjDateDiff() using any of these
installations I get a 'function not defined' error.

Can anybody tell me where ProjDateDiff is located or suggest why my Prj
installs can't seem to find it?

Thanks
Dave
[david dot moore at ngc dot com]

 

[doniy]

Projdatediff is a function in project, you can use with custom fields.
if you want to do the same thing in VBA, you should use application object
datedifference method, that is application.datedifference(
startdate,finishdate,[calendar])

Thanks, Jan - that did the trick. Just out of curiosity, if
ProjDateDiff does not exist in VBA, where are all of the folks who
write about it call it from?

Cheers
Dave

Hi,

Your VBA doesn't find it because in VBA it does not exist, as simple as
that.
Use Application.datedifference
HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620

All,

I work with a number of different installations of MSProject, including
Prj 2000 SR-1 and Prj Standard 2003. The references are set
appropriately in each (MSPRJ9.OLB for Prj 2K, OFFICE11\MSPRJ.OLB for
Prj 2003). Any time I try to call ProjDateDiff() using any of these
installations I get a 'function not defined' error.

Can anybody tell me where ProjDateDiff is located or suggest why my Prj
installs can't seem to find it?

Thanks
Dave
[david dot moore at ngc dot com]