Re: Showif date range comparison
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 24081
interpreted = N
texte = I ran into a similar problem when trying to add a markup to my shipping costdepending on the weight of a product. So basically I was trying to do somethinglike this:[showif [weight] is greater than or equal to 1 pound AND [weight] is less thanor equal to 5 pounds][math] [shipCost]+1[/math] [/showif]So if the weight was 4 pounds it would show [math][shipCost]+1[/math]I ended up doing something like this:[showif [weight]>0][showif [weight]<6]mark up 1 dollar[/showif][/showif][showif [weight]>5][showif [weight]<10]mark up 2 dollars[/showif][/showif][showif [weight]>10][showif [weight]<20]mark up 4 dollars[/showif][/showif][showif [weight]>20][showif [weight]<50]mark up 6 dollars[/showif][/showif]So if the weight=30 pounds it would show mark up 6 dollarsThis seems to work. I'm not sure if this helps your dilema or not but there yago. Working with ranges gives me a headache :)BrantBen Weinberg wrote:> I have set up a table with the heading cells set to show dates starting with> 1/1/99 and incrementing by 7 days per cell.>> There is a varable in each item record that is formatted as a date.>> I want to use the showif context to display some data in the record if the> date variable is between date1 and date2 . . . but can't get the comparison> to work.>>
[math date] week1={01/01/1999}[/math] | >
[format days_to_date %m/%d/%Y][math]> week2=[week1]+7[/math][/format] | > (and so on)> >>
[showif [Shipdate]ge[week1]][Minutes][/showif] | >> My above comparison is just testing one week and it doesn't work. The> manual isn't clear on the way to set this up. Can it be done?>> Ben Weinberg> ben@pca.com
Associated Messages, from the most recent to the oldest:
I ran into a similar problem when trying to add a markup to my shipping costdepending on the weight of a product. So basically I was trying to do somethinglike this:[showif [weight] is greater than or equal to 1 pound AND [weight] is less thanor equal to 5 pounds]
[math] [shipCost]+1[/math] [/showif]So if the weight was 4 pounds it would show
[math][shipCost]+1[/math]I ended up doing something like this:[showif [weight]>0][showif [weight]<6]mark up 1 dollar[/showif][/showif][showif [weight]>5][showif [weight]<10]mark up 2 dollars[/showif][/showif][showif [weight]>10][showif [weight]<20]mark up 4 dollars[/showif][/showif][showif [weight]>20][showif [weight]<50]mark up 6 dollars[/showif][/showif]So if the weight=30 pounds it would show mark up 6 dollarsThis seems to work. I'm not sure if this helps your dilema or not but there yago. Working with ranges gives me a headache :)BrantBen Weinberg wrote:> I have set up a table with the heading cells set to show dates starting with> 1/1/99 and incrementing by 7 days per cell.>> There is a varable in each item record that is formatted as a date.>> I want to use the showif context to display some data in the record if the> date variable is between date1 and date2 . . . but can't get the comparison> to work.>>
[math date] week1={01/01/1999}[/math] | >
[format days_to_date %m/%d/%Y][math]> week2=[week1]+7[/math][/format] | > (and so on)> >>
[showif [Shipdate]ge[week1]][Minutes][/showif] | >> My above comparison is just testing one week and it doesn't work. The> manual isn't clear on the way to set this up. Can it be done?>> Ben Weinberg> ben@pca.com
es-sleestak
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
weirdness in the error log (1998)
SetHeader not Working (2006)
OT - help with filemaker - short (1999)
Problem with webcat install (1998)
Sort Order on a page search (1997)
RE: pricing continued (1998)
problems with WebCat-Plugin (1997)
PIXO Support (1997)
[WebDNA] 6.2.1 fails on Apache 2.4.6 (2014)
How to find 100 most recent additions. (1997)
[WebDNA] Authorize.net SIM, Server Integration Method (2011)
Text data with spaces in them... (1997)
[WebDNA] Google map mashups (2010)
Ok here is a question? (1997)
[OT] DOD again (2003)
WCS Newbie question (1997)
WebCat2b15MacPlugIn - [authenticate] not [protect] (1997)
WebCatalog/Mac 2.1b2 New Features (1997)
looking for developers with solutions (2000)
[WriteFile] problems (1997)