Re: displaying New products (using [date])
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 13155
interpreted = N
texte = Dale:Keep your dates in the mm/dd/yy format: the calculations will be much easier and your data will be much cleaner. I think the only thing you need to add to the snippets I saw was [math date] instead of [math] so the output of the math context is a date rather than a number. Thanks.John.>Thanks, Olin! And aloha! > >I like your math better than mine! > >But even after cleaning the snippet up a little (needed data for sort >and an s with dir for sort direction), am still not getting the >desired calculation. > >Am pretty sure that it's because the OrigDate in my catalog.txt are in >mm/dd/yy format, instead of the number >of days format used for calculations. > >Anyone have suggestions around this? Or is the easiest solution to enter >OrigDate as the number of days since 1900 (and can FileMaker Pro do >that I wonder aloud?)? > >Thanks again, > >Dale Stokdyk >World Romance >dstokdyk@dvs.mv.com > > > >Olin wrote: > >>
> HREF=GiftResults.tmpl$search?db=catalog.txt&cart=[cart]&OrigDatetype=date& >> geOrigDate=[math]{[date]}-90[/math]&asOrigDatesort=1&OrigDatedir=de&max=10 > >COMPARE: > >HREF=GiftResults.tmpl$search?db=catalog.txt&cart=[cart]&geOrigDatedata=([math] >{[date]}-90[/math])&OrigDatesort=1&OrigDatesdir=de&max=10> > >> > >> >> Aloha, >> >> Olin >> >> ..................................................................... >> W O R L D P O I N T I N T E R A C T I V E OLIN KEALOHA LAGON >> director, website creation >> Honolulu San Francisco >> 2800 woodlawn drive 222 sutter street olin@worldpoint.com >> suite 170 sixth floor www.worldpoint.com >> honolulu, hi 96822 san francisco, ca 94108 >> >> voice.808.539.3978 fax.808.539.3943 cell.808.291.1610 >> ..................................................................... John A. Hill Pacific Coast Software 11770 Bernardo Plaza Ct. #453 * Web tools for Macintosh and WinNT * San Diego, CA 92128 http://www.smithmicro.com
Associated Messages, from the most recent to the oldest:
Dale:Keep your dates in the mm/dd/yy format: the calculations will be much easier and your data will be much cleaner. I think the only thing you need to add to the snippets I saw was [math date] instead of
[math] so the output of the math context is a date rather than a number. Thanks.John.>Thanks, Olin! And aloha! > >I like your math better than mine! > >But even after cleaning the snippet up a little (needed data for sort >and an s with dir for sort direction), am still not getting the >desired calculation. > >Am pretty sure that it's because the OrigDate in my catalog.txt are in >mm/dd/yy format, instead of the number >of days format used for calculations. > >Anyone have suggestions around this? Or is the easiest solution to enter >OrigDate as the number of days since 1900 (and can FileMaker Pro do >that I wonder aloud?)? > >Thanks again, > >Dale Stokdyk >World Romance >dstokdyk@dvs.mv.com > > > >Olin wrote: > >>
> HREF=GiftResults.tmpl$search?db=catalog.txt&cart=[cart]&OrigDatetype=date& >> geOrigDate=
[math]{
[date]}-90[/math]&asOrigDatesort=1&OrigDatedir=de&max=10 > >COMPARE: > >
HREF=GiftResults.tmpl$search?db=catalog.txt&cart=[cart]&geOrigDatedata=(
[math] >{
[date]}-90[/math])&OrigDatesort=1&OrigDatesdir=de&max=10> > >> > >> >> Aloha, >> >> Olin >> >> ..................................................................... >> W O R L D P O I N T I N T E R A C T I V E OLIN KEALOHA LAGON >> director, website creation >> Honolulu San Francisco >> 2800 woodlawn drive 222 sutter street olin@worldpoint.com >> suite 170 sixth floor www.worldpoint.com >> honolulu, hi 96822 san francisco, ca 94108 >> >> voice.808.539.3978 fax.808.539.3943 cell.808.291.1610 >> ..................................................................... John A. Hill Pacific Coast Software 11770 Bernardo Plaza Ct. #453 * Web tools for Macintosh and WinNT * San Diego, CA 92128 http://www.smithmicro.com
John Hill
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:
Emailer error 571 (1998)
[showif] and equality (1998)
Forcing a NEWCART (1997)
Calculating multiple shipping... (1997)
[url] (1997)
Removing [showif] makes a big difference in speed (1997)
Sendmail & Time Issue (2001)
OT: Where to turn (2003)
Re:Adding Multiple files to a cart at once (1998)
problems with 2 tags (1997)
many-to-one problem (1998)
OS X problem: when using [ShowCart] or [orderfile]... (2000)
Authenticate (1997)
New Plug-in and Type 11 errors (1997)
WebCatalog [FoundItems] Problem - AGAIN - (1997)
WebDNA Docs (2003)
Shopping Cart Problem (1998)
Comments in db? (1997)
command parameters (1998)
Is this too many webcat processes? (I don't know how to read this) (2000)