Re: Date Help
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 56426
interpreted = N
texte = Thanks for this the [text] bit has sorted it also using range. Thanks all. > Some of this has been said by others, but I'll clarify four points on > your issue: > > 1) I assume you have your WebDNA preferences set properly for UK date > formats. If not, it won't work properly. They are > 2) [math date] will return the value as a date in the format specified > in preferences, BUT, the math variable being set inside the math > context is actually holding the "days since 31Dec0000" value. You can > see this by displaying your SDate or EDate variables outside of the > math context. Math variables can only hold numbers, and 01/02/2004 is > not a number. To set a variable with the formatted date, you could use: > [text]SDate=[math date]{01/[date %m]/[date %Y]}[/math][/text] > > 3) You cannot directly search the same database field twice in a search > context - doing both a "geTSDatedatarq" and a "lsTSDatedatarq" in the > same search, one of them will be ignored. In this case, a range search > would be your answer: > > ...rnTSDatedatarq=[SDate]+[EDate]... > > 4) If you want a strict by-date sort, you should add "&allhit=1" to > your search string. This will disable WebDNA's best-match sorting. > Otherwise your date sort will be secondary to WebDNA's best-match sort > - records WebDNA considers to be equally ranked will be sorted by date. > It may not make a difference in your case, as WebDNA may consider all > found records to be equally ranked, but it is good practice whenever > you want a specific sort sequence. > > > - brian > > > On Feb 27, 2004, at 6:55 AM, Steve Craig wrote: > >> Hi >> >> OK, I am officially going off my head. I have re-used a piece of >> otherwise >> working code and it's not working and I cannot see why. Basically I >> want to >> return the timesheet records a given user for the current month. The >> records >> have a field called TSDATE which is in dd/mm/yyyy (UK Format). I know I >> could save these as numbers but would prefer to work in this format. >> >> (I have put a return in after each & in the search string to save any >> funny >> returns from the email.) >> >> [math date]SDate={01/[date %m]/[date %Y]}[/math] - >> 01/02/2004 >> [math date]EDate={01/[date %m]/[date %Y]}+{00/01/0000}[/math] - >> 01/03/2004 >> >> [search db=admin/-Timesheets.db& >> eqTSUserNamedatarq=[USERNAME]& >> geTSDATEdatarq=[SDate]& >> lsTSDATEdatarq=[EDate]& >> asTSDATEsort=1& >> TSDATEtype=date] >> >> >> Any help much appreciated, I'm sure its something silly. This code is >> just >> returning all records for that user. >> >> Cheers >> >> Steve Craig >> > > -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.com > -- > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list
. > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Thanks for this the [text] bit has sorted it also using range. Thanks all. > Some of this has been said by others, but I'll clarify four points on > your issue: > > 1) I assume you have your WebDNA preferences set properly for UK date > formats. If not, it won't work properly. They are > 2) [math date] will return the value as a date in the format specified > in preferences, BUT, the math variable being set inside the math > context is actually holding the "days since 31Dec0000" value. You can > see this by displaying your SDate or EDate variables outside of the > math context. Math variables can only hold numbers, and 01/02/2004 is > not a number. To set a variable with the formatted date, you could use: > [text]SDate=[math date]{01/[date %m]/[date %Y]}[/math][/text] > > 3) You cannot directly search the same database field twice in a search > context - doing both a "geTSDatedatarq" and a "lsTSDatedatarq" in the > same search, one of them will be ignored. In this case, a range search > would be your answer: > > ...rnTSDatedatarq=[SDate]+[EDate]... > > 4) If you want a strict by-date sort, you should add "&allhit=1" to > your search string. This will disable WebDNA's best-match sorting. > Otherwise your date sort will be secondary to WebDNA's best-match sort > - records WebDNA considers to be equally ranked will be sorted by date. > It may not make a difference in your case, as WebDNA may consider all > found records to be equally ranked, but it is good practice whenever > you want a specific sort sequence. > > > - brian > > > On Feb 27, 2004, at 6:55 AM, Steve Craig wrote: > >> Hi >> >> OK, I am officially going off my head. I have re-used a piece of >> otherwise >> working code and it's not working and I cannot see why. Basically I >> want to >> return the timesheet records a given user for the current month. The >> records >> have a field called TSDATE which is in dd/mm/yyyy (UK Format). I know I >> could save these as numbers but would prefer to work in this format. >> >> (I have put a return in after each & in the search string to save any >> funny >> returns from the email.) >> >> [math date]SDate={01/[date %m]/[date %Y]}[/math] - >> 01/02/2004 >> [math date]EDate={01/[date %m]/[date %Y]}+{00/01/0000}[/math] - >> 01/03/2004 >> >> [search db=admin/-Timesheets.db& >> eqTSUserNamedatarq=[username]& >> geTSDATEdatarq=[SDate]& >> lsTSDATEdatarq=[EDate]& >> asTSDATEsort=1& >> TSDATEtype=date] >> >> >> Any help much appreciated, I'm sure its something silly. This code is >> just >> returning all records for that user. >> >> Cheers >> >> Steve Craig >> > > -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.com > -- > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Steve Craig
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:
Searching for the end (1998)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
WebCatalog stalls (1998)
access denied problem (1997)
Help getting [shownext] to increment (2003)
Practice runs ? (1997)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)
WebCatalog/Mac 2.1b2 - PIXO (1997)
OT: Several requests (2003)
Multiple edits/replacementsd to db. Possible? (1997)
OT-test (1998)
WebCat2 - [format thousands] (1997)
WebCat2 - many [carts] on one template page? (1997)
Bug? (1997)
Searching multiple Databases (1997)
[WebDNA] Downloadable docs (2011)
multiple databases (1997)
Validating A Date (2004)
Performance Issue (2000)
Test (2002)