Quick Date ? 1

[rdjohnso]

What I have....

=TotalResourceCost("GWHIS",#1/1/2006#,#1/31/2006#)

What I need....

=TotalResourceCost("GWHIS",A1,B2)

A1 - should be 1st day of Jan, CurrentYr
B2 - should be Last day of Jan, CurrentYr

Ideas?

Thanks for assistance

 

[oharab]

=TotalResourceCost("GWHIS",dateserial(year(date),1,1),dateserial(year(date),2,1)-1)

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

We could be confused in exactly the same way, but confusion might be like Nulls, and not comparable.

 

[JerryKlmns]

Or

=TotalResourceCost("GWHIS", DateSerial(Year(Date), 1, 1), DateSerial(Year(Date), 2, 0))

 

[PHV]

And more evident:
=TotalResourceCost("GWHIS", DateSerial(Year(Date), 1, 1), DateSerial(Year(Date), 1, 31))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886