Re: Date Help
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 56422
interpreted = N
texte = Thanks for the replies on this so far but still no joy. If I just use one of the date bits then I get a correct answer, it's just when I do both that the problem happens. With this particular example I get nothing returned at all with both parts of the expression and a correct answer if I just use one of them. Any other ideas? Cheers Steve On 27/2/04 4:33 pm, "WebDna @ Inkblot Media"
wrote: > I did not see this get an answer, so I will toss in my findings. > > It appears to me that you are storing dates as dd/mm/yyyy but search on > 731948. You need to format the days to date to get back to dd/mm/yyyy after > you do the math to add a month. Or use the math directly in the search. > > [math date]SDate={01/[date %m]/[date %Y]}[/math] > [text]SDate=[Format Days_To_Date %d/%m/%y][SDate][/Format][/text] > [math date]EDate={01/[date %m]/[date %Y]}+{00/01/0000}[/math] > [text]EDate=[Format Days_To_Date %d/%m/%y][EDate][/Format][/text] > > - or - > > [search db=admin/-Timesheets.db& > eqTSUserNamedatarq=[USERNAME]& > geTSDATEdatarq=[math date]{01/[date %m]/[date %Y]}[/math] & > lsTSDATEdatarq=[math date]{01/[date %m]/[date %Y]}+{00/01/0000}[/math]& > asTSDATEsort=1& > TSDATEtype=date] > > I hope this helps. > > ----- Original Message ----- > From: "Steve Craig" > To: "WebDNA Talk" > Sent: Friday, February 27, 2004 6:55 AM > Subject: Date Help > > >> 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 >> >> >> >> ------------------------------------------------------------- >> 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/ > ------------------------------------------------------------- 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 the replies on this so far but still no joy. If I just use one of the date bits then I get a correct answer, it's just when I do both that the problem happens. With this particular example I get nothing returned at all with both parts of the expression and a correct answer if I just use one of them. Any other ideas? Cheers Steve On 27/2/04 4:33 pm, "WebDna @ Inkblot Media" wrote: > I did not see this get an answer, so I will toss in my findings. > > It appears to me that you are storing dates as dd/mm/yyyy but search on > 731948. You need to format the days to date to get back to dd/mm/yyyy after > you do the math to add a month. Or use the math directly in the search. > > [math date]SDate={01/[date %m]/[date %Y]}[/math] > [text]SDate=[Format Days_To_Date %d/%m/%y][SDate][/Format][/text] > [math date]EDate={01/[date %m]/[date %Y]}+{00/01/0000}[/math] > [text]EDate=[Format Days_To_Date %d/%m/%y][EDate][/Format][/text] > > - or - > > [search db=admin/-Timesheets.db& > eqTSUserNamedatarq=[username]& > geTSDATEdatarq=[math date]{01/[date %m]/[date %Y]}[/math] & > lsTSDATEdatarq=[math date]{01/[date %m]/[date %Y]}+{00/01/0000}[/math]& > asTSDATEsort=1& > TSDATEtype=date] > > I hope this helps. > > ----- Original Message ----- > From: "Steve Craig" > To: "WebDNA Talk" > Sent: Friday, February 27, 2004 6:55 AM > Subject: Date Help > > >> 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 >> >> >> >> ------------------------------------------------------------- >> 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/ > ------------------------------------------------------------- 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:
BUG?- .html extention and not working. (2000)
FW: Shipping calculations (1997)
shownext & searchstring (2000)
SSL and reg web* (1997)
[format xs] freeze (1997)
Memory Error message (1998)
Multiple catalog databases and showcart (1997)
WC2f3 (1997)
b18 problem on NT 4.0 (1997)
How do I make this faster???? (2000)
[WebDNA] Question on table search (2011)
Displaying photo attached to first record (1997)
[WebDNA] [OT] Mac Audit Software? (2009)
Dates (1998)
Virtual Postcards (1998)
[OT] KeepItUp for Windows (2003)
[WebDNA] Fwd: RETS... HELP! (2009)
WebCat2b12 CGI Mac -- Problems propagating the cart through (1997)
[format xs] freeze (1997)
Webcatalog error, Plug-in for Webstar (1996)