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:

[WebDNA] sudo and shell (2010) RE: [WebDNA] Installing WebDNA on Windows 7 64 Bit, Home Premium (2010) HomePage Caution (1997) Harvesting invalid email addresses from bounced emails??? (2000) Error Log.db --however (1997) Ken's grep question about renaming files to lowercase (2003) Creating main- and sub-category search (1997) A multi-processor savvy WebCatalog? (1997) Fun with Dates - finally resolved but.... (1997) splitting up items in a cart (1999) Problems passing [SKU] with $Replace in 2.0 (1997) Busy WebCatalog (2000) Rendering out a page (1997) email address scrambling (2002) Trigger Woes (1999) Change in Host? (1999) [append] vs. [appendfile] delta + question? (1997) Virtual hosting and webcatNT (1997) Forms Search Questions (1997) taxRate is fine but taxTotal isn't (1997)