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:
Signal Raised Error (1997)
Here we go again... (2006)
[WebDNA] Libmysql.dll error (2009)
restarting webcatalog (2002)
WebCat2b13MacPlugIn - syntax to convert date (1997)
Do search engines index .tpl pages? (2006)
[SearchString] usage (1997)
Images do not upload completely ... (2003)
Mac Sever Web Hosting (1999)
Building Calendars (1997)
View Source from cache (1997)
[append] vs. [appendfile] delta + question? (1997)
DreamWeaver (2002)
oops private message leaked into talk list (1997)
RE: Multiple Stores and WebCatalog Prefs (1997)
[WebDNA] [OT] WebDNA Wiki - need grammar check / suggestions (2009)
NT Woes (1997)
Sendmail and textarea (1998)
delete a file? (1998)
won't serve .tpl (2000)