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:
Can't use old cart file (was One more try) (1997)
Getting total number of items ordered (1997)
Upgrade to web DNA6.0 problem (2004)
changing prices in cart (1997)
Strange intermittent WebDNA problems (2008)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
db access problem after switching to SSL (2001)
still having shipCost.db Problem (1997)
Items XX to XX shown (1997)
Newbie problem blah blah blah (1997)
[WebDNA] Dreamweaver Tag Libraries and Snippets (2010)
read and write you own cookies with webcat (1997)
Cool ShowNext (was Blasted shownext (request for 4.0)) (1998)
2nd WebCatalog2 Feature Request (1996)
WebCat hosting providers? (1997)
[url] (1997)
color and size options (1997)
SKU lookup (1997)
Weird error/limit - something amiss? (1997)
carriage returns in data (1997)