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:

eMail volume (2000) PCS Emailer's role ? (1997) [WebDNA] An unknown error occured // Deadlock avoided (2011) Displaying photo attached to first record (1997) Protect folder (2005) Toronto area? (1999) Cart Transfer from Un-Secure to Secure (2000) Encrypted Templates Serving as Text (2000) Upgrading old WebCat Database Files (1997) Text Areas, Sendmail and returns.... (2002) REPOST [SUM field=xxxx] (2000) Off Topic: Frames Killer? (1998) OS X, Communigate Pro & Line Breaks (2003) ImageMagick (2003) [price] via a search (1998) [WebDNA] File Upload Issue (2012) More on ShippingCost help needed (1998) [WriteFile] problems (1997) stumped [OT] (2001) WC2b12: Yes, Formulas.db is for real (1997)