Ok I have a project in which I must find the days active each project took based on dates. Assuming the project has an end date.

For example

I have the Date Initiated as 2008-Sep 29 05:09pm
I have Task Ready 09/29/2008 5:21PM
I have Task Done 9/25/2008 05:25PM
I have Task Status: Either Executing or Started

I need to put together VB code to calculate the days active of this project based on these variables.

Any help please?

Thanks

Elie

you can use datediff() function to count days.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.