Re: Showif date > other date
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 56763
interpreted = N
texte = On Mar 11, 2004, at 5:26 PM, Kenneth Grome wrote: > Hi Tim, > > I also forgot to mention that we often store dates in three separate > fields (month, day, year) because those fields match our common use of > three popup fields in our forms. > > We have found that it is often easier to match each form field with a > corresponding database field than to combine the three into a single > formatted date to be stored in one field ... and then to split this > date field value into three separate components when re-populating the > same three form fields again (such as in an edit form). > > Besides, sometimes we need to search for people whose birthdays are > coming soon (within the next 30 days for example) and you have to > ignore the year in this kind of search, so using three separate fields > makes this search easier as well. How would you do a range search if your data was stored like that? -- Jesse Williams-Proudman Blue Box Development :: Custom Web Solutions +1.206.778.8777 :: jesse@blueboxdev.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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
On Mar 11, 2004, at 5:26 PM, Kenneth Grome wrote: > Hi Tim, > > I also forgot to mention that we often store dates in three separate > fields (month, day, year) because those fields match our common use of > three popup fields in our forms. > > We have found that it is often easier to match each form field with a > corresponding database field than to combine the three into a single > formatted date to be stored in one field ... and then to split this > date field value into three separate components when re-populating the > same three form fields again (such as in an edit form). > > Besides, sometimes we need to search for people whose birthdays are > coming soon (within the next 30 days for example) and you have to > ignore the year in this kind of search, so using three separate fields > makes this search easier as well. How would you do a range search if your data was stored like that? -- Jesse Williams-Proudman Blue Box Development :: Custom Web Solutions +1.206.778.8777 :: jesse@blueboxdev.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://webdna.smithmicro.com/
Jesse Proudman
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 within tmpl ? (1997)
.html to .tpl; ***TIP (1998)
WC 2.0 frames feature (1997)
two unique banners on one page (1997)
Odd