Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

date percentaga calculations

Status
Not open for further replies.

muffntuf

MIS
Jan 7, 2003
155
US
I need to test for one date being less than, = to or > another date:

If datecreated <= needbydate then

if the date is less than or equal to I need to get the difference of days as a percentage. So if something was created on the 1st of the month and was due by the 9th, but today is the 10th, then I am overdue by 1 day. But I need to show it as a percentage.

How can I do that?
 
Hi,
As a percentage of what?



[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
If a datecreated were past the dateneeded then I need to know in a percentage format what the percentage of over the target (dateneeded) it is.
 
yeah I see your point now, percentage of what?? LOL!
 
LOL! I figured it out, just the way the question was posed to me. Thanks everyone!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top