Thanks anyway but I got it. DATEDIFF function.
> I have a form whereby the user enters an ADMIT date into a text input box.
> After the submit button is clicked the then I have to pass the admit date
> via a parameter into a SQL table as well as a calculated field in the
> #ofdays field in the hospital. I have tried the following without success
> because I do not know how to calculate the # of days from the date format
> (ANY SUGGESTIONS OR DIRECTION WOULD BE APPRECIATED!):
>
> strdate = trim(date)
> If strdate <> "" Then
> If Not IsEmpty(strtoday) And Not IsNull(strtoday) Then
> If len(trim(Request.Form("ptadmitdate"))) > 0 Then
> strpthd = trim(strtoday - (Request.Form("ptadmitdate")))
> End If
> End If
> End If
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
