Formatting the standard rate

[JimS]

Hi,

I'm using the resource standard rate in a macro and even though my local
setting is a daily rate, the value coming out of resource.standardrate is the
hourly rate. Is there anyway that I can pull it out as a daily rate as I'm
getting rounding errors when multiplying it up myself.

Cheers
JimS

 

[John]

Hi,

I'm using the resource standard rate in a macro and even though my local
setting is a daily rate, the value coming out of resource.standardrate is the
hourly rate. Is there anyway that I can pull it out as a daily rate as I'm
getting rounding errors when multiplying it up myself.

Cheers
JimS

Jim,
Ah but Project likes to work with hourly rates regardless of the entered
value. I'm sure the entered daily rate is available if the Project
database is queried directly but that would be more work so sometimes
you need to think outside the box. It may seem a little Mickey Mouse but
first have the code transfer the daily rate from the Standard Rate field
to a Resource text field. Then use the data from the text field
(stripped of the currency sign and "/d") as the real resource rate.

Obviously this method gets a little dicey if multiple pay rates per
resource are in effect but then you just need a bigger box to think
outside of

John