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:

rn doesn't work on date fields (1998) Re:2nd WebCatalog2 Feature Request (1996) Review comparison by PC Magazine: Open for On-line Business (1997) Using Plug-In while running 1.6.1 (1997) database visibility (2000) Need help with search title (1998) [WebDNA] WebDNA on Windows Server 2008 (2009) access denied problem (1997) Default contains WEBDNA (1998) tag request (1999) Drop Down Menus (2002) Encyption mail was Suggestions for Topics ... (1998) Auto entering Friday's date in a field (2002) Obtaining a dice result (2007) too many nested tags ... (1997) Another bug to squash (WebCat2b13 Mac .acgi) (1997) Running _every_ page through WebCat-error.html (1997) Help formatting search results w/ table (1997) WebCat & WebTen (1997) problems with 2 tags (1997)