date manipulation problem

[gsc123]

Hi

I'm trying to manipulate some dates to give my time left

pStartDate = rsTemp("startDate")
pEndDate = rsTemp("endDate")

both dates from rsTemp are from the db and are date/time data types - on the asp end I what to do soething like this


DateDiff("d",Now(),pEndDate)

I want to return time left? DateDiff just returns a Variant (Long) but I'm not sure how to use it

 

[gmmastros]

One thing you could try doing is to subtract the 2 values. When you subtract 2 dates, the result is a single representing the number of days. Ex:

<%
	
	pEndDate = cdate("5/27/2009 8:39:20 PM")
	response.write cDate(pEndDate - Now)
%>

On my server, this displays: 3:34:26 AM

Which means there is 3 hours, 34 minutes, and 26 second until 8:39:20 PM. You'll probably want to play around with the formatting to get it to your liking.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[gsc123]

The problem is I get these dates/times from a database - just entering the date into the cdate function is not an option, its when I try to manipulate the dates is the problem now minus then etc

 

[gsc123]

If i say

theTimeLeft = pStartDate - pEndDate

I get values like

9.00009259259241

 

[gmmastros]

Can you show some typical values you get from the database? Also, what type of database are you using?


-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[gmmastros]

Also.... I suggest you take a look at this:

http://blogs.lessthandot.com/index.php/DesktopDev/MSTech/VB56/vb6-remove-date-part-of-datetime

It's meant for VB6, but I'm 99.9% sure that it would work here too.



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[gsc123]

For the moment I'm using access - values are like thus>

27/05/2009 21:15:50

 

[gsc123]

Are you say I have to literally manipulation the date and time string?

 

[gsc123]

Surely there must be an easier way than just doing the math on the minutes? or seconds even?

theTimeEnd=DateDiff("n",pStartDate,pEndDate)