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:
[convertChars] and HTML Tags (1997)
Searching an Email database (1997)
different browser, different result (2000)
[OT] Change permissions via FTP? (2002)
[WebDNA] Credit card processing (2012)
Passing info in [Addlineitem] (1997)
Searching for the end (1998)
WebCat2.0 [format thousands .0f] no go (1997)
Performance: deafening silence (1999)
The word TYPE in search contexts and fields (1998)
What would be sweet is (2003)
Nested tags count question (1997)
"Advanced" Search Algorithm (2008)
WebCat2 beta 11 - new prefs ... (1997)
YACBQ.....(Yet another checkbox question) (2000)
syntax question, not in online refernce (1997)
Sharing with you my Online help system (2006)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
Re:PCS Customer submissions ? (1997)
CSV import suggestions (2007)