Re: Fun with dates

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 12278
interpreted = N
texte = >Anyone got any ideas on this ?? I'm still stumped... > >I'm trying to give my users the ability to search for events which start in >the next xxx days using pull-downs and a math context but I can't seem to >get it to work. My code is: > > > > days. > >Whereas int3 is the starting date, stored in the database as mm/dd/yyyy >format. I've never used pulldowns in combination with a math context so I'm >probably missing something obvious but I couldn't find any examples or help >in the docs. > >Thanks as always >-marty This is not the way you want it but here is the code I used with radio buttons. Notice the difference in the math. Change to minus to plus and make the last one plus a bunch of days instead of 180 in my example. If I remember right I struggled also to get the mm/dd/yy to work right when doing the math date stuff. But I know the following gives me what I needed as far as results. This was written back during the beta days so maybe somebody at PSC fixed something since I wrote this and I didn't go back and change it to use mm/dd/yy.
Click on the Button of how Far Back you would like to Search.

List InDash Part Numbers Added or Updated in the last 60 days

List InDash Part Numbers Added or Updated in the last 120 days

List InDash Part Numbers Added or Updated in the last 180 daysHave not fooled around much with pull downs so I can't help you with that part of the html. But I might make a suggestion that you prove out your webDNA [math] maybe with radio buttons first and get the pages working before you try the pull downs. That is unless the WebDNA Master Ken jumps in :). Or he might be busy in a holy war started on the webstar talk list with Nathan from purity (weg).=============================================== Gary Richter PanaVise Products, Inc. 7540 Colbert Dr. Reno, Nevada 89511 Ph: 702.850.2900 Fx: 702.850.2929 Email: grichter@panavise.com http://www.panavise.com =============================================== Associated Messages, from the most recent to the oldest:

    
  1. Re: Fun with Dates (syntax) (Gary Krockover 2002)
  2. Re: Fun with Dates (syntax) (spam 2002)
  3. Re: Fun with Dates (syntax) (Gary Krockover 2002)
  4. Re: Fun with Dates (syntax) (Brian Boegershausen 2002)
  5. Fun with Dates (syntax) (spam 2002)
  6. Re: Fun with Dates - any progress? (Grant Hulbert 1997)
  7. Fun with Dates - any progress? (Marty Schmid 1997)
  8. Fun with Dates - revisited (again) (Marty Schmid 1997)
  9. Re: Fun with Dates - revisited (Kenneth Grome 1997)
  10. Re: Fun with Dates - revisited (Marty Schmid 1997)
  11. Re: Fun with Dates - revisited (Grant Hulbert 1997)
  12. Fun with Dates - revisited (Marty Schmid 1997)
  13. Re: Fun with Dates - finally resolved but.... (Christer Olsson 1997)
  14. Re: Fun with Dates - finally resolved but.... (marty@artwerks.com (Marty Schmid) 1997)
  15. Re: Fun with Dates - finally resolved but.... (Kenneth Grome 1997)
  16. Fun with Dates - finally resolved but.... (marty@artwerks.com (Marty Schmid) 1997)
  17. Re: Fun with dates (Kenneth Grome 1997)
  18. Re: Fun with dates (Richard Wylie 1997)
  19. Re: Fun with dates (Marty Schmid 1997)
  20. Re: Fun with dates (Kenneth Grome 1997)
  21. Re: Fun with dates (grichter@panavise.com (Gary Richter) 1997)
  22. Re: Fun with dates (Grant Hulbert 1997)
  23. Fun with dates (Marty Schmid 1997)
  24. Fun with dates (Marty Schmid 1997)
>Anyone got any ideas on this ?? I'm still stumped... > >I'm trying to give my users the ability to search for events which start in >the next xxx days using pull-downs and a math context but I can't seem to >get it to work. My code is: > > > > days. > >Whereas int3 is the starting date, stored in the database as mm/dd/yyyy >format. I've never used pulldowns in combination with a math context so I'm >probably missing something obvious but I couldn't find any examples or help >in the docs. > >Thanks as always >-marty This is not the way you want it but here is the code I used with radio buttons. Notice the difference in the math. Change to minus to plus and make the last one plus a bunch of days instead of 180 in my example. If I remember right I struggled also to get the mm/dd/yy to work right when doing the math date stuff. But I know the following gives me what I needed as far as results. This was written back during the beta days so maybe somebody at PSC fixed something since I wrote this and I didn't go back and change it to use mm/dd/yy.
Click on the Button of how Far Back you would like to Search.

[date]}-60[/math]>List InDash Part Numbers Added or Updated in the last 60 days

[date]}-120[/math]> List InDash Part Numbers Added or Updated in the last 120 days

[date]}-180[/math]>List InDash Part Numbers Added or Updated in the last 180 daysHave not fooled around much with pull downs so I can't help you with that part of the html. But I might make a suggestion that you prove out your webDNA [math] maybe with radio buttons first and get the pages working before you try the pull downs. That is unless the WebDNA Master Ken jumps in :). Or he might be busy in a holy war started on the webstar Talk List with Nathan from purity (weg).=============================================== Gary Richter PanaVise Products, Inc. 7540 Colbert Dr. Reno, Nevada 89511 Ph: 702.850.2900 Fx: 702.850.2929 Email: grichter@panavise.com http://www.panavise.com =============================================== grichter@panavise.com (Gary Richter)

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:

[LOOKUP] (1997) Questions about searching (1999) 4.5.1 upgrade fee (2003) HELP..Changing Price after adding to cart. (1999) WebCat2b12 CGI Mac - [shownext] problem (1997) Nested tags count question (1997) SQL - Output into file (2004) WebCat2 - many [carts] on one template page? (1997) WC on Mac OS X or Mac OS X Server 2.x (2001) anyone using Webcat 4.x in production? (2000) Re:Searching for ALL / empty form field (1997) Country & Ship-to address & other fields ? (1997) Other then credit cards-how? (1997) Need relative path explanation (1997) Is [thisurl] http or https? (1998) bypassing typo's (1998) Calculating [subtotal] (2000) Sorting by date (1997) Mac app. that converts e-mails (2000) 2nd try: possible to weight results of grouped fieldssearch? (1998)