469,322 Members | 1,573 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,322 developers. It's quick & easy.

Couting Days

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.

Mar 7 '07 #1
2 1375
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?

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)
Mar 7 '07 #2
On Mar 7, 4:56 pm, "Evertjan." <exjxw.hannivo...@interxnl.netwrote:
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?

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)
Figured it out like this- ( ended up not using vbs )

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

Thanks though.

Mar 7 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

38 posts views Thread by | last post: by
reply views Thread by Johnson, Shaunn | last post: by
29 posts views Thread by james | last post: by
19 posts views Thread by Ricardo Perez Lopez | last post: by
7 posts views Thread by Mike | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by Gurmeet2796 | last post: by
reply views Thread by mdpf | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.