Re: displaying New products (using [date])
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 13148
interpreted = N
texte = Thanks, Olin! And aloha!I like your math better than mine! But even after cleaning the snippet up a little (needed data for sortand an s with dir for sort direction), am still not getting thedesired calculation. Am pretty sure that it's because the OrigDate in my catalog.txt are inmm/dd/yy format, instead of the numberof days format used for calculations. Anyone have suggestions around this? Or is the easiest solution to enterOrigDate as the number of days since 1900 (and can FileMaker Pro dothat I wonder aloud?)?Thanks again,Dale StokdykWorld Romancedstokdyk@dvs.mv.comOlin wrote:>
HREF=GiftResults.tmpl$search?db=catalog.txt&cart=[cart]&OrigDatetype=date&> geOrigDate=[math]{[date]}-90[/math]&asOrigDatesort=1&OrigDatedir=de&max=10COMPARE: > >> > 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> .....................................................................
Associated Messages, from the most recent to the oldest:
Thanks, Olin! And aloha!I like your math better than mine! But even after cleaning the snippet up a little (needed data for sortand an s with dir for sort direction), am still not getting thedesired calculation. Am pretty sure that it's because the OrigDate in my catalog.txt are inmm/dd/yy format, instead of the numberof days format used for calculations. Anyone have suggestions around this? Or is the easiest solution to enterOrigDate as the number of days since 1900 (and can FileMaker Pro dothat I wonder aloud?)?Thanks again,Dale StokdykWorld Romancedstokdyk@dvs.mv.comOlin wrote:>
HREF=GiftResults.tmpl$search?db=catalog.txt&cart=[cart]&OrigDatetype=date&> geOrigDate=
[math]{
[date]}-90[/math]&asOrigDatesort=1&OrigDatedir=de&max=10COMPARE:
[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> .....................................................................
Dale Stokdyk
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:
Fwd: Problems with Webcatalog Plug-in (1997)
Ariba XML support help needed (2004)
Quickie question on the email templates (1997)
PCS Frames (1997)
service stop and restart (1997)
Here we go again...WebDNA - SQL- Clustering (2006)
Country & Ship-to address & other fields ? (1997)
Upgrading to 4.0 (2000)
Serving images from databases (1998)
serial number generation (1997)
WebCat and AppleShare 6.0 (1998)
[createfolder] & [deletefolder] (1997)
How Many SKU's is enough? (1997)
authenticate (2002)
& Aftermath (2000)
[WebDNA] GREP problem (2011)
Possible Bug in 2.0b15.acgi (1997)
Replace Statement (1997)
WebCat2b12--[searchstring] bug (1997)
Announcement-WebCatalog 2.0 Released (1997)