KnightShift Posted September 28, 2004 Posted September 28, 2004 I can quite get a handle on this solution. The object is to take a date that is in a vendor form field (date of their approval as a vendor)subtract that date from "Today's" date (no problem there). And then if the number of days from the date field to today's date is 1 to 305 days, show result "A", if number of days (here's where I have the problem in the equation) is 306 to 335 days, show result "B", if the number of days is over 336 days, show result "C". I've tried case statements, if statements etc and can't seem to get htis working quite right. The problem area is the spanning the second part of the equation, proceeding through the third part before a result is displayed.
transpower Posted September 28, 2004 Posted September 28, 2004 Case ( X < 305 , "A" ; X < 336 , "B" ; "C" )
Recommended Posts
This topic is 7360 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now