Re: Help with dates

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 38268
interpreted = N
texte = Thanks Tom, I never thought of that. Gorana> Gorana, > > Your problem is to with today's date being the 29th, when you subtract the > month it appears that you are getting 29/2/2001 which is then interpretted > as 1/3/2001 giving you two listings for March. > > That's the problem, haven't figured out the solution yet :) > > - Tom > > > > > Gorana Leahy wrote: > > > > > > > > Hi all, > > > > > > > > I hope that someone can help me with this problem. > > > > > > > > I need to display quantity for a given number of months > > and this is the > > code > > > > I am using: > > > > > > > > [loop start=0&end=[math][txtmonths]-1[/math]] > > > > > > > > > > > > [search db=some.db&eqIDdatarq=[ID]&rnDaydatarq=01/[MyMonth] > > > > 31/[MyMonth]&Daytype=date] > > > > [founditems] > > > > > > > > > > > > [/founditems] > > > > [/search] > > > >
[MyMonth] > > > > [math]MonthTotal[/math] > > > > [/loop] > > > > > > > > These are the results: > > > > > > > > 08/2001 1106 > > > > 07/2001 1044 > > > > 06/2001 0 > > > > 05/2001 0 > > > > 04/2001 0 > > > > 03/2001 0 > > > > 03/2001 0 > > > > 01/2001 0 > > > > 12/2000 0 > > > > 11/2000 0 > > > > > > > > For some reason I keep on getting March instead of February. > > > > I tryed everything to solve the problem but nothing works. > > > > PLEASE HELP?! :) > > > > > > > > > Try using [math date] instead (as the docs say): > > > > > > [math date]{[date]}-{00/[index]/0000}[/Math] > > > > > > HTH > > > > > > John > > > > > > -- > > > John Peacock > > > Director of Information Research and Technology > > > Rowman & Littlefield Publishing Group > > > 4720 Boston Way > > > Lanham, MD 20706 > > > 301-459-3366 x.5010 > > > fax 301-429-5747 > > > > > I tried that and the result is still the same. > > > > Gorana > > > > > > ------------------------------------------------------------- > > 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://search.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://search.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://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Help with dates (John Peacock 2001)
  2. Re: Help with dates (Gorana Leahy 2001)
  3. Re: Help with dates (Gorana Leahy 2001)
  4. Re: Help with dates (John Peacock 2001)
  5. Re: Help with dates (Will Starck 2001)
  6. Re: Help with dates (John Peacock 2001)
  7. Re: Help with dates (Tom Duke 2001)
  8. Re: Help with dates (Tom Duke 2001)
  9. Re: Help with dates (Gorana Leahy 2001)
  10. Re: Help with dates (John Peacock 2001)
  11. Help with dates (Gorana Leahy 2001)
  12. Re: HELP WITH DATES (Kenneth Grome 1997)
  13. Re: HELP WITH DATES (Jim Shaughnessy 1997)
  14. Re: HELP WITH DATES (John Hill 1997)
  15. Re: HELP WITH DATES (grichter@panavise.com (Gary Richter) 1997)
  16. Re: HELP WITH DATES (Jim Shaughnessy 1997)
  17. Re: HELP WITH DATES (Grant Hulbert 1997)
  18. Re: HELP WITH DATES (Kenneth Grome 1997)
  19. HELP WITH DATES (John Hill 1997)
Thanks Tom, I never thought of that. Gorana> Gorana, > > Your problem is to with today's date being the 29th, when you subtract the > month it appears that you are getting 29/2/2001 which is then interpretted > as 1/3/2001 giving you two listings for March. > > That's the problem, haven't figured out the solution yet :) > > - Tom > > > > > Gorana Leahy wrote: > > > > > > > > Hi all, > > > > > > > > I hope that someone can help me with this problem. > > > > > > > > I need to display quantity for a given number of months > > and this is the > > code > > > > I am using: > > > > > > > > [loop start=0&end=[math][txtmonths]-1[/math]] > > > > > > > > > > > > [search db=some.db&eqIDdatarq=[ID]&rnDaydatarq=01/[MyMonth] > > > > 31/[MyMonth]&Daytype=date] > > > > [founditems] > > > > > > > > > > > > [/founditems] > > > > [/search] > > > >
[MyMonth] > > > > [math]MonthTotal[/math] > > > > [/loop] > > > > > > > > These are the results: > > > > > > > > 08/2001 1106 > > > > 07/2001 1044 > > > > 06/2001 0 > > > > 05/2001 0 > > > > 04/2001 0 > > > > 03/2001 0 > > > > 03/2001 0 > > > > 01/2001 0 > > > > 12/2000 0 > > > > 11/2000 0 > > > > > > > > For some reason I keep on getting March instead of February. > > > > I tryed everything to solve the problem but nothing works. > > > > PLEASE HELP?! :) > > > > > > > > > Try using [math date] instead (as the docs say): > > > > > > [math date]{[date]}-{00/[index]/0000}[/Math] > > > > > > HTH > > > > > > John > > > > > > -- > > > John Peacock > > > Director of Information Research and Technology > > > Rowman & Littlefield Publishing Group > > > 4720 Boston Way > > > Lanham, MD 20706 > > > 301-459-3366 x.5010 > > > fax 301-429-5747 > > > > > I tried that and the result is still the same. > > > > Gorana > > > > > > ------------------------------------------------------------- > > 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://search.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://search.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://search.smithmicro.com/ Gorana Leahy

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) Hiding HTML and page breaks (1997) WebDNA on Windows questions (2007) How to add product size choices to form? (1997) Problem with imagemap variables (2006) Re:2nd WebCatalog2 Feature Request (1996) Date comparison has serious bug ... (1998) showif and cart (1997) [WebDNA] Error 500 with SUMM=T (2017) Search design (1997) [WebDNA] triggers executed at boot instead of scheduled time (2011) Bug or syntax error on my part? (1997) Authenticate (1997) [WebDNA] New request for websites that currently run WebDNA (2009) [WebDNA] Debian Lenny, Lighttpd and WebDNA FastCGI ... (2010) BUG REPORT: numeric ge, le, gr & ls comparisons don't work ... (1999) ReplaceFoundItems (2006) [WebDNA] Quick Grep question (2009) Slightly OT - SQL- Clustering (2006) Reload adding to cart (2001)