Re: Help with dates
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 38261
interpreted = N
texte = Goranna,Try the following for your date calculation:- [math]{1/[date %m]/[date %Y]}-{00/[index]/0000}[/Math]That seems to be working on my system.- 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:
Goranna,Try the following for your date calculation:- [math]{1/[date %m]/[date %Y]}-{00/[index]/0000}[/Math]That seems to be working on my system.- 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:
[thisurl] file name? (1999)
math on date? (1997)
multiple search commands (1997)
How to include weather (2000)
[OT] gMail accounts (2004)
WebDNA Engine Won't Start (2003)
MacWEEK article help needed (1996)
[WebDNA] An actual attempt to get WebDNA and MAMP Pro to work - (2018)
Setting up shop (1997)
Maybe off topic but how to charge (1997)
off topic - dna snipets (1997)
[OT] two domains one site... (2005)
PCS Frames (1997)
pc (1997)
Nesting format tags (1997)
Free WebDNA snippets (Extending WebCatalog) (1997)
Balancing randomness (2000)
Wanted: More Math Functions (or, Can You Solve This?) (1997)
Budget system (2003)
[WebDNA] math date issues? (2013)