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:
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)