RE: ANother SHOWIF problem
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 13473
interpreted = N
texte = Michael ->In my database, I have divided the on sale date of an item into month>(1-12), day (1-31), and year (01-99) fields (for a number of reasons).>If the current date is before the on sale date, I'd like to display some>info (so anything past September 16th will display the on sale date).>For some reason, the following code (which is inside a [SEARCH] context)>*always* displays the on sale date.>[SHOWIF [MATH][DATE][/MATH]<[MATH]{[MTH]/[DAY]/[YR]}[/MATH]]
On sale>[MTH]/[DAY]/[YR][/SHOWIF]>My date pref is set to %m/%d/%Y>I've tried it with WebCat 2.0 and 2.01.>The clock on the web server is correct.Try this instead:[SHOWIF {[DATE]}<{[MTH]/[DAY]/[YR]}]
On sale [MTH]/[DAY]/[YR][/SHOWIF]It appears to work for me.Hope this helps,Marc EagleStarNine Technologieshttp://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Michael ->In my database, I have divided the on sale date of an item into month>(1-12), day (1-31), and year (01-99) fields (for a number of reasons).>If the current date is before the on sale date, I'd like to display some>info (so anything past September 16th will display the on sale date).>For some reason, the following code (which is inside a
[search] context)>*always* displays the on sale date.>[SHOWIF
[math][date][/MATH]<
[math]{[MTH]/[DAY]/[YR]}[/MATH]]
On sale>[MTH]/[DAY]/[YR][/SHOWIF]>My date pref is set to %m/%d/%Y>I've tried it with WebCat 2.0 and 2.01.>The clock on the web server is correct.Try this instead:[SHOWIF {
[date]}<{[MTH]/[DAY]/[YR]}]
On sale [MTH]/[DAY]/[YR][/SHOWIF]It appears to work for me.Hope this helps,Marc EagleStarNine Technologieshttp://www.smithmicro.com/
Marc Eagle
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:
Statistics... (2004)
math on date? (1997)
[WebDNA] Just drop the Server version (2015)
creator code (1997)
Separate SSL Server (1997)
setlineiems and UnitShip Cost (2000)
no global [username] or [password] displayed ... (1997)
[WebDNA] OT, environment variables os x (2012)
[WebDNA] [PROTECT] - Log Out (2011)
List Address Changed! (1998)
cart info (1998)
Problem (1997)
WebCatalog Use Question (1997)
WebSTAR 2.1 freezes my Mac (1997)
cookies and [returnraw] (1997)
MasterCounter Weirdness -Resolved! (1997)
[format 40s]text[/format] doesn't work (1997)
pc (1997)
More NT encyption!! (1999)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)