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:

Simple way to create unique SKU (1997) WebCatalog [FoundItems] Problem - LONG - (1997) Web Developer Product Awards (1997) This list needs a digest: rant, rave... (1997) serial number generation (1997) The word TYPE in search contexts and fields (1998) wierd [cart] action! (1997) WebCatalog-NT?'s (1996) upgrading (1997) WebCat2 beta 11 - new prefs ... (1997) Mac: [ListFiles] bug alert (1997) Upcoming 2.1 Release and PCS Committment (1997) Putting & into a database (1999) [delete] problem (1997) possible, WebCat2.0 and checkboxes-restated (1997) Which [index]? (1997) EIMS & emailer conflicts? (1999) WebCat2.0 [format thousands .0f] no go (1997) WebCat2 - Getting to the browser's username/password data (1997) Hidden or Forbidden? (1998)