Re: Help with dates

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 38259
interpreted = N
texte = 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/ 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)
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/ Tom Duke

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:

Help! WebCat2 bug (1997) Date format problems (1997) Whats going on with my SERIAL NUMBER??? (1998) Generating Report Totals (1997) WebCatalog/WebMerchant 2.1 (1998) The Form authentication trick (2000) A Global Variable (1997) WebCatalog can't find database (1997) Help name our technology! (1997) Pre-flight public flag (1997) WebCat2 beta 11 - new prefs ... (1997) Re:2nd WebCatalog2 Feature Request (1996) question: writing files textb in webmerch (1997) Date/Time format problems (1997) Every other record deleted (2005) Nested tags count question (1997) Secure server question (1997) weird happenings (1997) WebCatalog f2 Installation (1997) Re:HTTP header line is too long? (1997)