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:

Re:Why did PCS send me this? (1999) [OT] WebDNA Family Album (2004) Question about links (1999) [OT] MacOs IE5 topmargin and leftmargin bug (2000) Discounting prices across a site (1997) WebCat and Personal Web Server (1998) Weird Math and SV (1997) [searchString] (1997) WebDNA Solutions ... sorry! (1997) [OT] HTML EMAIL program wanted (1999) [OT] (waaaay OT) (2004) carriage returns in data (1997) WebCatalog 4.0.2b5 install problems (2000) DomainList (2005) Multi-processor Mac info ... (1997) HomePage Caution (1997) WebCatalog Technical Reference (1997) 2nd WebCatalog2 Feature Request (1996) Search: Is this possible? (2005) Configuring E-mail (1997)