Re: Showif date > other date
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 56765
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?A range search only work on one field, so I would do a greater than/less than search.-- Kenneth GromeWebDNA ProgrammerOutsource Service ProviderPhone: +6332 255-6591-------------------------------------------------------------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?A range search only work on one field, so I would do a greater than/less than search.-- Kenneth GromeWebDNA ProgrammerOutsource Service ProviderPhone: +6332 255-6591-------------------------------------------------------------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/
Kenneth Grome
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:
docs for WebCatalog2 (1997)
WebCat2: multiple currency support (1997)
[WebDNA] after latest OSX upgrade, WebDNA not running? (2011)
[WebDNA] [OT] Free Windows FTP client recommendations (2009)
Questions To Answer (1997)
Replace Statement (1997)
math problems (2000)
WebCat b13 CGI -shownext- (1997)
[WebDNA] directly talk to FileMaker databases? (2009)
Great product and great job ! (1997)
[OT] Site Check please (2006)
RE: extended ASCII with middle command (1999)
populating a [table] (2004)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
listfiles-looking for slick solution (1997)
Emailer setup (1997)
surf express & webcat (1998)
Nav. 4 probs with cart - Serious problem (1997)
WebCat2 - many [carts] on one template page? (1997)
Number searching/formats (1998)