Re: [WebDNA] search by range of dates

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 103993
interpreted = N
texte = --Apple-Mail-22-524133005 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit How are you storing the dates in your db ? In number format or mm/dd/yyy ? If it is numbers, this will probably do the trick for you. Find everything from 10 days ago until today [search db=/temp.db&rnFORMATTED_DATEdatarq=[Math]{[date]}-10[/Math] [Math]{[date]}[/Math]&deFORMATTED_DATEsort=1] If mm/dd/yyyy, then try this [search db=/temp.db&rnFORMATTED_DATEdatarq=[Format days_to_date %m/%d/ %Y][Math]{[date]}-10[/Math][/Format] [Math]{[date]}[/ Math]&deFORMATTED_DATEsort=1&FORMATTED_DATEtype=date] Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 12/11/2009, at 3:50 PM, sbraun wrote: > Thanks Stuart, your help made sense, so I added it, but it's still > not working for me. > I'm trying to return only the records within the preceding 10 days. > here's my code, the field name is FORMATTED_DATE: > > [text]TENDAYSAGO=[math date]{[date]}-10[/math][/text] > [search db=/ > temp > .db > &grSKUdata > = > 0 > &FORMATTED_DATEtype > =date&TENDAYSAGOtype=date&leFORMATTED_DATEdatarq=[date][!] > [/!]&geFORMATTED_DATEdata=[TENDAYSAGO]&deFORMATTED_DATEsort=1] > > Any ideas for me? Thanks, > sfb > > > On Nov 11, 2009, at 10:01 PM, Stuart Tremain wrote: > >> Add this to your search ... >> >> &FIELDNAMEtype=date >> >> Regards >> Stuart Tremain > >> On 12/11/2009, at 1:42 PM, sbraun wrote: >>> >>> I wish to run a search to find a range of dates 10 days before >>> today, and 10 days following today. >>> I can easily set the two before and after variable dates in xx/xx/ >>> xxxx format, but I can't seem to get the search tag to return any >>> results between these two variables. > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: http://forum.webdna.us/eucabb.html?page=topics&category=288 --Apple-Mail-22-524133005 Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable How are you storing the dates = in your db ?

In number format or mm/dd/yyy = ?

If it is numbers, this will probably do the = trick for you.

Find everything from 10 days ago = until today

[search = db=3D/temp.db&rnFORMATTED_DATEdatarq=3D[Math]{[date]}-10[/Math] = [Math]{[date]}[/Math]&deFORMATTED_DATEsort=3D1]

If mm/dd/yyyy, then try this

[search = db=3D/temp.db&rnFORMATTED_DATEdatarq=3D[Format days_to_date = %m/%d/%Y][Math]{[date]}-10[/Math][/Format] = [Math]{[date]}[/Math]&deFORMATTED_DATEsort=3D1&FORMATTED_DATEtype=3D= date]





Regards

Stuart = Tremain
IDFK Web Developments
AUSTRALIA



=

On 12/11/2009, at 3:50 PM, sbraun wrote:

Thanks = Stuart,  your help made sense, so I added it,  but it's still = not working for me.
I'm trying to return only the records within the = preceding 10 days.
here's my code, the field name is = FORMATTED_DATE:

[text]TENDAYSAGO=3D[math = date]{[date]}-10[/math][/text]
[search = db=3D/temp.db&grSKUdata=3D0&FORMATTED_DATEtype=3Ddate&TENDAYSA= GOtype=3Ddate&leFORMATTED_DATEdatarq=3D[date][!]
[/!]&geFORMATT= ED_DATEdata=3D[TENDAYSAGO]&deFORMATTED_DATEsort=3D1]

Any = ideas for me?  Thanks,
sfb


On Nov 11, 2009, at 10:01 = PM, Stuart Tremain wrote:

Add this to = your search ...

&FIELDNAMEtype=3Ddate

Regards
Stuart = Tremain

On 12/11/2009, at = 1:42 PM, sbraun wrote:

I wish to run a search to find a = range of dates 10 days before today, and 10 days following = today.
I can easily set the two before and after variable dates = in xx/xx/xxxx format, but I can't seem to get the search tag to return = any results between these two = variables.
----------------------------------= -----------------------
This message is sent to you because you are = subscribed to
the mailing list <talk@webdna.us>.
To = unsubscribe, E-mail to: <talk-leave@webdna.us>
archi= ves: http://mail.webdna.us/l= ist/talk@webdna.us
old archives: http://dev.webdna.us/TalkLi= stArchive/
Bug Reporting: http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D288=

= --Apple-Mail-22-524133005-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] search by range of dates (sbraun 2009)
  2. Re: [WebDNA] search by range of dates (Govinda 2009)
  3. Re: [WebDNA] search by range of dates (Donovan Brooke 2009)
  4. Re: [WebDNA] search by range of dates (Govinda 2009)
  5. Re: [WebDNA] search by range of dates ("Terry Wilson" 2009)
  6. Re: [WebDNA] search by range of dates (sbraun 2009)
  7. Re: [WebDNA] search by range of dates (Stuart Tremain 2009)
  8. Re: [WebDNA] search by range of dates ("Terry Wilson" 2009)
  9. Re: [WebDNA] search by range of dates (Govinda 2009)
  10. Re: [WebDNA] search by range of dates (sbraun 2009)
  11. Re: [WebDNA] search by range of dates (Stuart Tremain 2009)
  12. [WebDNA] search by range of dates (sbraun 2009)
--Apple-Mail-22-524133005 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit How are you storing the dates in your db ? In number format or mm/dd/yyy ? If it is numbers, this will probably do the trick for you. Find everything from 10 days ago until today [search db=/temp.db&rnFORMATTED_DATEdatarq=[math]{[date]}-10[/Math] [math]{[date]}[/Math]&deFORMATTED_DATEsort=1] If mm/dd/yyyy, then try this [search db=/temp.db&rnFORMATTED_DATEdatarq=[Format days_to_date %m/%d/ %Y][math]{[date]}-10[/Math][/Format] [math]{[date]}[/ Math]&deFORMATTED_DATEsort=1&FORMATTED_DATEtype=date] Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 12/11/2009, at 3:50 PM, sbraun wrote: > Thanks Stuart, your help made sense, so I added it, but it's still > not working for me. > I'm trying to return only the records within the preceding 10 days. > here's my code, the field name is FORMATTED_DATE: > > [text]TENDAYSAGO=[math date]{[date]}-10[/math][/text] > [search db=/ > temp > .db > &grSKUdata > = > 0 > &FORMATTED_DATEtype > =date&TENDAYSAGOtype=date&leFORMATTED_DATEdatarq=[date][!] > [/!]&geFORMATTED_DATEdata=[TENDAYSAGO]&deFORMATTED_DATEsort=1] > > Any ideas for me? Thanks, > sfb > > > On Nov 11, 2009, at 10:01 PM, Stuart Tremain wrote: > >> Add this to your search ... >> >> &FIELDNAMEtype=date >> >> Regards >> Stuart Tremain > >> On 12/11/2009, at 1:42 PM, sbraun wrote: >>> >>> I wish to run a search to find a range of dates 10 days before >>> today, and 10 days following today. >>> I can easily set the two before and after variable dates in xx/xx/ >>> xxxx format, but I can't seem to get the search tag to return any >>> results between these two variables. > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: http://forum.webdna.us/eucabb.html?page=topics&category=288 --Apple-Mail-22-524133005 Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable How are you storing the dates = in your db ?

In number format or mm/dd/yyy = ?

If it is numbers, this will probably do the = trick for you.

Find everything from 10 days ago = until today

[search = db=3D/temp.db&rnFORMATTED_DATEdatarq=3D[math]{[date]}-10[/Math] = [math]{[date]}[/Math]&deFORMATTED_DATEsort=3D1]

If mm/dd/yyyy, then try this

[search = db=3D/temp.db&rnFORMATTED_DATEdatarq=3D[Format days_to_date = %m/%d/%Y][math]{[date]}-10[/Math][/Format] = [math]{[date]}[/Math]&deFORMATTED_DATEsort=3D1&FORMATTED_DATEtype=3D= date]





Regards

Stuart = Tremain
IDFK Web Developments
AUSTRALIA



=

On 12/11/2009, at 3:50 PM, sbraun wrote:

Thanks = Stuart,  your help made sense, so I added it,  but it's still = not working for me.
I'm trying to return only the records within the = preceding 10 days.
here's my code, the field name is = FORMATTED_DATE:

[text]TENDAYSAGO=3D[math = date]{[date]}-10[/math][/text]
[search = db=3D/temp.db&grSKUdata=3D0&FORMATTED_DATEtype=3Ddate&TENDAYSA= GOtype=3Ddate&leFORMATTED_DATEdatarq=3D[date][!]
[/!]&geFORMATT= ED_DATEdata=3D[TENDAYSAGO]&deFORMATTED_DATEsort=3D1]

Any = ideas for me?  Thanks,
sfb


On Nov 11, 2009, at 10:01 = PM, Stuart Tremain wrote:

Add this to = your search ...

&FIELDNAMEtype=3Ddate

Regards
Stuart = Tremain

On 12/11/2009, at = 1:42 PM, sbraun wrote:

I wish to run a search to find a = range of dates 10 days before today, and 10 days following = today.
I can easily set the two before and after variable dates = in xx/xx/xxxx format, but I can't seem to get the search tag to return = any results between these two = variables.
----------------------------------= -----------------------
This message is sent to you because you are = subscribed to
the mailing list <talk@webdna.us>.
To = unsubscribe, E-mail to: <talk-leave@webdna.us>
archi= ves: http://mail.webdna.us/l= ist/talk@webdna.us
old archives: http://dev.webdna.us/TalkLi= stArchive/
Bug Reporting: http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D288=

= --Apple-Mail-22-524133005-- Stuart Tremain

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:

Looking up two prices in database? (1997) Dealer Locator (zip codes) (2003) [isfile] ? (1997) For those of you not on the WebCatalog Beta... (1997) my SOS last week... (1996) WebDNA Running Out of RAM? (2004) shell question (2004) Problems passing [SKU] with $Replace in 2.0 (1997) FYI: virus alert (1996) International Orders (1998) Tiger / WebDNA (2005) Trouble with Netscape (1998) Searching for all records (1998) Best way to download a db (2003) 3RD POST Character limit in [Search]? (1998) Tax & Shipping (1997) How true is this? (1999) Generate a SKU (1998) Stumpted Again (1997) Location of Browser Info.txt file (1997)