conditional displays

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

conditional displays

Logged in as: Guest

arrSession:exec spGetSession 2,3,1172

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> ASP >> conditional displays
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

conditional displays - 7/23/2004 6:24:36 AM

DancingGeek

Posts: 1
Score: 0
Joined: 7/23/2004
From: USA
Status: offline

I am trying to display database output and Using Response.Write to create an output table. I want to have rolling values for January through december. I have two sets of values to work with Jan -Dec "Actuals" and Jan - Dec "forecast"

For each month I want to look at the month number (Jan = 1, feb = 2 etc...) If the month is less than the current month display the actual, if the month is >= current month display forecast.

Can I do this within my table results or should I select it that way in my stored proc?

Thanks!

Post #: 1

Re: conditional displays - 8/17/2004 10:00:10 PM

Matt

Posts: 30
Score: 0
Joined: 8/17/2004
From: United Kingdom
Status: offline

you can use the Month() function to pull out the number

ie
If Month(MyDate) < 2 then
do MyThing
Else
Do My other thing
End If

Is that what you mean?

(in reply to DancingGeek)