Help with Date Count

[Hoangsta]

I want to count the number of days between the date() - field date

my field date is a text field actually. what I have so far,

line 449 dayCount = " "

line 450 dayCount = round(rst ("Text4") - date())


line 451 Response.Write("<td align='right' class='detData'" & rowClass & ">" & dayCount & "</td></tr>")

above all of this coding is my SQL to pull out the data...the error that it's giving me is.

Type mismatch: '[string: "9/25/2006"]'

line 450 , i'm thinking that it's missing the #

[Hoangsta]

oh my god. i just looked thru the database that the last developer did and there is text in it!!! hahdhahdhahdh. let me figure this one out....and get back to you guys

[Hoangsta]

i took out the text, but it's not working....should there be a #9/25/2006# ?

[brianadkins]

If your date is in an undesireable (but recognizable) format, you can use the strtotime() function to turn it into a 'real' date.

http://us3.php.net/strtotime

[Hoangsta]

I output my text field and it shows 9/25/2006, the format that i want.

is there some error with trying to get the count of days between 9/25/2006 - now()

IssuedayCount = round(rst("Text4") - now())

the "Text4" is coming from my database that holds 9/25/2006. I am trying to get the day count from the Text4 to today's date.

For example, if my Text4 has a date of 9/25/2006, I want it to - (minus) today's Date to give me the actual Day that has passed. So, if today's date is 9/26/2006, then IssueDayCount = 1

cool? 😕

[brianadkins]

$YourDateString="9/25/2006"
$YourTime=strtotime($YourDateString); // time in seconds from Jan 1, 1970
$ElapsedSeconds=time() - $YourTime; // elapsed time in seconds from then until now
$ElapsedDays = $ElapsedSeconds/(3600*24);

... now just round that off as required.

[Hoangsta]

this shouldn't be soooooo difficult. it should be simple!!!

<%

	Response.Write("<td align='right' class='detData' " & rowClass & "> " & date() & " </td>")
	Response.Write("<td align='right' class='detData' " & rowClass & ">" & rst("Text4") & "</td>")

	IssueDate = "" & rst("Text4") & ""
	TodayDate = "" & date() & ""

	IssueDayCount = round(IssueDate - TodayDate)

	Response.Write("<td align='right' class='detData'" & rowClass & ">" & IssueDayCount & "</td></tr>")

%>[/COLOR]

Error:

Type mismatch: '[string: "9/25/2006"]'

Line: IssueDayCount = round(IssueDate - TodayDate)

I don't know why it's giving me a mismatch error. My Text Field Data Type is Text. User enters in a date in a Text field. I was able to extract it just fine. but when it compares.....with Text4 - TodayDate, it fails. can someone help me out here. All the codes that users are giving me would be helpful if the initial input of date were something else. But it's not.

I see the database Text4 = 9/25/2006

I just extracted out from a SQL which does show me 9/25/2006. why is it so hard to get the difference of days from that to the Present Date???????????!!!!!!!!! what is going on!!!!!!!! Giving me an error. :mad:

[Hoangsta]

if anyone wants to try this out...create a table in access, make it has a data type of text. enter in a date and try to get the difference of day with just that.

Days Gone by = Whatever is in the database - date()

try that before giving me the code cause i tried everything.

[Hoangsta]

i figure it out that no the data type in the database needs to be date/time in order for it to work....

IssueDayCount = round(rst("Date1") - Now())

	Response.Write("<td align='right' class='detData'" & rowClass & ">" & IssueDayCount & "</td></tr>")

Where the "DATE1" needs to be in that Data Type of date/time. is there a way to convert a text field into a date/time without having to go into the database itself? can i PHP the script to something like...given that Date1 wasn't a date/time, but a text type that has this value 9/25/2006

format(Date1, ....... i don't know. is this possible???