Couting Days

[Mangler]

Not sure how to do this but I need to display the count of days on the
page where the start date is the result of the record set and the end
date is the current date. So if the record set value was 3/04/2007
than the display on the page would be "3" ( with todays date:
3/07/2007 as the end date). I know I need to use datediff(d,???? )
you can see where I get lost.

 

[Evertjan.]

Mangler wrote on 07 mrt 2007 in microsoft.public.inetserver.asp.general:

Not sure how to do this but I need to display the count of days on the
page where the start date is the result of the record set and the end
date is the current date. So if the record set value was 3/04/2007
than the display on the page would be "3" ( with todays date:
3/07/2007 as the end date). I know I need to use datediff(d,???? )

difference = DateDiff("d", now, recordSetDate )

you can see where I get lost.

No, I cannot, sorry, but you do not show your code.

Perhaps reading vbs specs could have helped you?

 

[Mangler]

Mangler wrote on 07 mrt 2007 in microsoft.public.inetserver.asp.general:


difference = DateDiff("d", now, recordSetDate )


No, I cannot, sorry, but you do not show your code.

Perhaps reading vbs specs could have helped you?

Figured it out like this- ( ended up not using vbs )

datediff(d,(o.open_dte),(getdate())) As 'Day''s '

Thanks though.