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 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.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:

    
  1. Re: displaying New products (using [date]) (John Hill 1997)
  2. Re: displaying New products (using [date]) (Dale Stokdyk 1997)
  3. Re: displaying New products (using [date]) (Olin 1997)
  4. displaying New products (using [date]) (Dale Stokdyk 1997)
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.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)