Re: Showif date > other date
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 56761
interpreted = N
texte = 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. >Ken, > >We also store all dates as numbers, but if you're using a date comparison >with a specific date, then you still have to code it in a date format - the >date preference format (unless you happen to know the number since 0). > >Regards, >Tim > >> From: Kenneth Grome
>> Reply-To: (WebDNA Talk) >> Date: Fri, 12 Mar 2004 08:56:34 +0800 >> To: (WebDNA Talk) >> Subject: Re: Showif date > other date >> >> That's two different preferences you have to set properly if you >> change the default date format, right? Maybe this has been the cause >> of some people's problems when not using the default date format, >> they perhaps changed only one of the two date format preferences. >> >> I have never stored dates in formats other than "days since 0000" and >> American format (which is webdna's default) but over the years there >> have been numerous problems posted when people try doing things with >> dates in different formats, so I thought this was still not possible. >> >> Thanks for confirming this, but I will personally continue to store >> dates in the default format (or as days since 0000) just to prevent >> any potential new problems in the future ... :) >> >> >> >>> Ken >>> >>> If the prefs are set to read and display European dates the code will work. >>> >>> I use this code with European Dates set in WebDNA prefs >>> >>> [If >>> >>>("[Math]{[Date]}[/Math]">"[Math]{01/02/2004}[/Math]")|("[Math]{[Date]}[/Math] >>> "="[Math]{01/02/2004}[/Math]")] >>> [Then] [!]***** show new *****[/!] [Include >>> file=promos/feb04promo.inc] [/Then] >>> [Else] [!]***** show old *****[/!] [Include >>> file=promos/oct03promo.inc] [/ELSE] >>> [/If] >>> >>> >>> >>> On 12 Mar 2004, at 10:30 AM, Kenneth Grome wrote: >>> >>>> The math context can only deal with dates in American format, >>>> right? If so, he will have to change the date format first, because >>>> he's not using American date format ... >>> Regards >>> >>> Stuart Tremain >>> idfk web developments >>> 114a/40 yeo street neutral bay 2089 australia >>> t +612 9908 2134 >>> f +612 9908 4837 >>> >>> >>> ------------------------------------------------------------- >>> 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 >> WebDNA Programmer >> Outsource Service Provider >> Phone: +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/ > > >------------------------------------------------------------- >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 WebDNA Programmer Outsource Service Provider Phone: +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:
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. >Ken, > >We also store all dates as numbers, but if you're using a date comparison >with a specific date, then you still have to code it in a date format - the >date preference format (unless you happen to know the number since 0). > >Regards, >Tim > >> From: Kenneth Grome >> Reply-To: (WebDNA Talk) >> Date: Fri, 12 Mar 2004 08:56:34 +0800 >> To: (WebDNA Talk) >> Subject: Re: Showif date > other date >> >> That's two different preferences you have to set properly if you >> change the default date format, right? Maybe this has been the cause >> of some people's problems when not using the default date format, >> they perhaps changed only one of the two date format preferences. >> >> I have never stored dates in formats other than "days since 0000" and >> American format (which is webdna's default) but over the years there >> have been numerous problems posted when people try doing things with >> dates in different formats, so I thought this was still not possible. >> >> Thanks for confirming this, but I will personally continue to store >> dates in the default format (or as days since 0000) just to prevent >> any potential new problems in the future ... :) >> >> >> >>> Ken >>> >>> If the prefs are set to read and display European dates the code will work. >>> >>> I use this code with European Dates set in WebDNA prefs >>> >>> [If >>> >>>("[math]{[date]}[/Math]">"[math]{01/02/2004}[/Math]")|("[math]{[date]}[/Math] >>> "="[math]{01/02/2004}[/Math]")] >>> [Then] [!]***** show new *****[/!] [Include >>> file=promos/feb04promo.inc] [/Then] >>> [Else] [!]***** show old *****[/!] [Include >>> file=promos/oct03promo.inc] [/ELSE] >>> [/If] >>> >>> >>> >>> On 12 Mar 2004, at 10:30 AM, Kenneth Grome wrote: >>> >>>> The math context can only deal with dates in American format, >>>> right? If so, he will have to change the date format first, because >>>> he's not using American date format ... >>> Regards >>> >>> Stuart Tremain >>> idfk web developments >>> 114a/40 yeo street neutral bay 2089 australia >>> t +612 9908 2134 >>> f +612 9908 4837 >>> >>> >>> ------------------------------------------------------------- >>> 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 >> WebDNA Programmer >> Outsource Service Provider >> Phone: +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/ > > >------------------------------------------------------------- >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 WebDNA Programmer Outsource Service Provider Phone: +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:
WC2.0 Memory Requirements (1997)
[WebDNA] o search engines index .db files? (2009)
RE: Price recalc based on quantity (1997)
[WebDNA] WebDNA future (2010)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
Help! WebCat2 bug (1997)
This is probably a stupid question... (2004)
Typhoon Rev. and PCS store problems (1999)
Search wbrk word break param (1998)
Sorting (1998)
Authorize.net? (2003)
WebCat/Typhoon Status under Windows (1998)
customizing the color of user's pages (1997)
WebCat2b13MacPlugIn - [include] (1997)
Template Encryption (1998)
[shell] (2002)
Suffix Mapping (1997)
Resume Catalog ? (1997)
[WebDNA] Facebook Application - Custom Tab for Fan / Non-Fan (2011)
Netscape Communicator 4 chops off URLs (was No Data) (1997)