[BULK] Re: [WebDNA] Format Days_To_Date

This WebDNA talk-list message is from

2008


It keeps the original formatting.
numero = 100814
interpreted = N
texte = Actually I was using it as part of a "Nifty" little routine to determine an age as of a certain date. I used the %y as the age. At least until sometime this spring when it stopped working. Oh well. Thanks for the comments. -tim On 9/4/08 6:40 PM, "Stuart Tremain" wrote: > Defines how WebDNA will interpret two digit years when performing > 'date' math. It is strongly recommended that you always specify a four > digit year for any date calculations. But, in the event that WebDNA is > given a two digit year, this preference will allow you to control how > WebDNA will calculate the century. By default, the 'Century Break' is > set to '00'. This means that '00' will be interpreted as '2000', and > '01' - '99' as '1901' - '1999'. If, for example, you set the 'Century > Break' to '30', WebDNA will interpret '00' - '30' as '2000' - '2030' > and '31' - '99' as '1931' - '1999'. > > I changed the setting to 1000 and it still doesn't work until 1900 > > So it looks like you will need to use %Y rather than %y to get the > date correct. > > On 05/09/2008, at 8:30 AM, Terry Wilson wrote: > >> I haven't been following this thread too closely, but remember, >> there's a setting in the WebDNA prefs to tell webDNA where to break >> the century. I.e., whether 10/20/25 is seen as 1925 or 2025. I don't >> know if this has anything to do with the original problem or not. >> >> >>> Here's a littel test to show where it starts working, 1900: >>> [loop start=360&end=740062&advance=365] >>> [text show=t]testdate=[Format Days_To_Date %m/%d/%Y][index][/ >>> Format][/text] >>> - >>> [text show=t]testdate=[Format Days_To_Date %m/%d/%y][index][/ >>> Format][/text]
>>> [/loop] >>> >>> Marc >>> >>> Stuart Tremain wrote: >>>> And did you notice that there is NO example of the output ???? >>>> >>>> On 05/09/2008, at 8:01 AM, Marc Thompson wrote: >>>> >>>>> Incidentally, [Format Days_To_Date %m/%d/%y]195462[/Format] comes >>>>> directly from the WebDNA Reference guide under >>>>> [Format FormatSpec]Text or Number[/Format] >>>>> >>>>> Marc >>>>> >>>>> Terry Wilson wrote: >>>>>> You don't know that this date is not relevant. For instance, a >>>>>> quick Google search tells us that Krakatoa erupted in 535 A.D. >>>>>> Or maybe the original poster is putting together a website for >>>>>> things happening in the Dark Ages. >>>>>>> I got the same! >>>>>>> >>>>>>> When I change to %Y I got 02/27/0535 >>>>>>> >>>>>>> >>>>>>> Try using a more relevant date/number such as 733655 >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> On 05/09/2008, at 5:13 AM, Tim Benson wrote: >>>>>>> >>>>>>>> This line [text]testdate=[Format Days_To_Date %m/%d/%y]195462[/ >>>>>>>> Format][/text] >>>>>>>> Produces >>>>>>>> testdate = 02/27/*+ >>>>>>>> >>>>>>>> I expected a number. >>>>>>>> >>>>>>>> tim >>>>>>>> >>>>>>>> On 9/3/08 11:15 AM, "Paul Willis" wrote: >>>>>>>> >>>>>>>>> What do you get back and what are you expecting? >>>>>>>>> >>>>>>>>> %y is the year without century so 08 at the moment >>>>>>>>> %Y is the year with century so 2008 at the moment >>>>>>>>> >>>>>>>>> ...or my guess is you are using this inside an [orderfile] >>>>>>>>> where date stuff doesn't work as normal. >>>>>>>>> >>>>>>>>> Paul >>>>>>>>> >>>>>>>>> >>>>>>>>> On 3 Sep 2008, at 15:54, Tim Benson wrote: >>>>>>>>> >>>>>>>>>> The formatting option [Format Days_To_Date %m/%d/%y] no >>>>>>>>>> longer supplies the year properly, was it replaced or no >>>>>>>>>> longer supported? >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> Timothy D. Benson (tbenson@syracusecoe.org) >>>>>>>>>> Information Coordinator >>>>>>>>>> SyracuseCoE >>>>>>>>>> 621 Skytop Road >>>>>>>>>> Syracuse, NY 13244 >>>>>>>>>> Tel:315-443-8756 >>>>>>>>>> Web:SyracuseCoe.org >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>> >>>>>>> --------------------------------------------------------- >>>>>>> This message is sent to you because you are subscribed to >>>>>>> the mailing list . >>>>>>> To unsubscribe, E-mail to: >>>>> >>>>> -- ------------------------------------------- >>>>> Marc Thompson >>>>> Software Engineer >>>>> Office of Information Technology >>>>> University of Utah >>>>> 801.585.9264 >>>>> marc.thompson@utah.edu >>>>> ------------------------------------------- >>>>> --------------------------------------------------------- >>>>> This message is sent to you because you are subscribed to >>>>> the mailing list . >>>>> To unsubscribe, E-mail to: >>>> --------------------------------------------------------- >>>> This message is sent to you because you are subscribed to >>>> the mailing list . >>>> To unsubscribe, E-mail to: >>>> >>> >>> -- >>> ------------------------------------------- >>> Marc Thompson >>> Software Engineer >>> Office of Information Technology >>> University of Utah >>> 801.585.9264 >>> marc.thompson@utah.edu >>> ------------------------------------------- >>> --------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >> >> -- >> Terry Wilson | terry@terryfic.com | http://terryfic.com >> http://WhosComing.com - a simplified, affordable online reservation >> system >> http://TightJacket.com -- stylish protection for your laptop >> -------------------------------------------------------------------------- >> Attitude is the only difference between ordeal and adventure. >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: Associated Messages, from the most recent to the oldest:

    
Actually I was using it as part of a "Nifty" little routine to determine an age as of a certain date. I used the %y as the age. At least until sometime this spring when it stopped working. Oh well. Thanks for the comments. -tim On 9/4/08 6:40 PM, "Stuart Tremain" wrote: > Defines how WebDNA will interpret two digit years when performing > 'date' math. It is strongly recommended that you always specify a four > digit year for any date calculations. But, in the event that WebDNA is > given a two digit year, this preference will allow you to control how > WebDNA will calculate the century. By default, the 'Century Break' is > set to '00'. This means that '00' will be interpreted as '2000', and > '01' - '99' as '1901' - '1999'. If, for example, you set the 'Century > Break' to '30', WebDNA will interpret '00' - '30' as '2000' - '2030' > and '31' - '99' as '1931' - '1999'. > > I changed the setting to 1000 and it still doesn't work until 1900 > > So it looks like you will need to use %Y rather than %y to get the > date correct. > > On 05/09/2008, at 8:30 AM, Terry Wilson wrote: > >> I haven't been following this thread too closely, but remember, >> there's a setting in the WebDNA prefs to tell webDNA where to break >> the century. I.e., whether 10/20/25 is seen as 1925 or 2025. I don't >> know if this has anything to do with the original problem or not. >> >> >>> Here's a littel test to show where it starts working, 1900: >>> [loop start=360&end=740062&advance=365] >>> [text show=t]testdate=[Format Days_To_Date %m/%d/%Y][index][/ >>> Format][/text] >>> - >>> [text show=t]testdate=[Format Days_To_Date %m/%d/%y][index][/ >>> Format][/text]
>>> [/loop] >>> >>> Marc >>> >>> Stuart Tremain wrote: >>>> And did you notice that there is NO example of the output ???? >>>> >>>> On 05/09/2008, at 8:01 AM, Marc Thompson wrote: >>>> >>>>> Incidentally, [Format Days_To_Date %m/%d/%y]195462[/Format] comes >>>>> directly from the WebDNA reference guide under >>>>> [Format FormatSpec]Text or Number[/Format] >>>>> >>>>> Marc >>>>> >>>>> Terry Wilson wrote: >>>>>> You don't know that this date is not relevant. For instance, a >>>>>> quick Google search tells us that Krakatoa erupted in 535 A.D. >>>>>> Or maybe the original poster is putting together a website for >>>>>> things happening in the Dark Ages. >>>>>>> I got the same! >>>>>>> >>>>>>> When I change to %Y I got 02/27/0535 >>>>>>> >>>>>>> >>>>>>> Try using a more relevant date/number such as 733655 >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> On 05/09/2008, at 5:13 AM, Tim Benson wrote: >>>>>>> >>>>>>>> This line [text]testdate=[Format Days_To_Date %m/%d/%y]195462[/ >>>>>>>> Format][/text] >>>>>>>> Produces >>>>>>>> testdate = 02/27/*+ >>>>>>>> >>>>>>>> I expected a number. >>>>>>>> >>>>>>>> tim >>>>>>>> >>>>>>>> On 9/3/08 11:15 AM, "Paul Willis" wrote: >>>>>>>> >>>>>>>>> What do you get back and what are you expecting? >>>>>>>>> >>>>>>>>> %y is the year without century so 08 at the moment >>>>>>>>> %Y is the year with century so 2008 at the moment >>>>>>>>> >>>>>>>>> ...or my guess is you are using this inside an [orderfile] >>>>>>>>> where date stuff doesn't work as normal. >>>>>>>>> >>>>>>>>> Paul >>>>>>>>> >>>>>>>>> >>>>>>>>> On 3 Sep 2008, at 15:54, Tim Benson wrote: >>>>>>>>> >>>>>>>>>> The formatting option [Format Days_To_Date %m/%d/%y] no >>>>>>>>>> longer supplies the year properly, was it replaced or no >>>>>>>>>> longer supported? >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> Timothy D. Benson (tbenson@syracusecoe.org) >>>>>>>>>> Information Coordinator >>>>>>>>>> SyracuseCoE >>>>>>>>>> 621 Skytop Road >>>>>>>>>> Syracuse, NY 13244 >>>>>>>>>> Tel:315-443-8756 >>>>>>>>>> Web:SyracuseCoe.org >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>> >>>>>>> --------------------------------------------------------- >>>>>>> This message is sent to you because you are subscribed to >>>>>>> the mailing list . >>>>>>> To unsubscribe, E-mail to: >>>>> >>>>> -- ------------------------------------------- >>>>> Marc Thompson >>>>> Software Engineer >>>>> Office of Information Technology >>>>> University of Utah >>>>> 801.585.9264 >>>>> marc.thompson@utah.edu >>>>> ------------------------------------------- >>>>> --------------------------------------------------------- >>>>> This message is sent to you because you are subscribed to >>>>> the mailing list . >>>>> To unsubscribe, E-mail to: >>>> --------------------------------------------------------- >>>> This message is sent to you because you are subscribed to >>>> the mailing list . >>>> To unsubscribe, E-mail to: >>>> >>> >>> -- >>> ------------------------------------------- >>> Marc Thompson >>> Software Engineer >>> Office of Information Technology >>> University of Utah >>> 801.585.9264 >>> marc.thompson@utah.edu >>> ------------------------------------------- >>> --------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >> >> -- >> Terry Wilson | terry@terryfic.com | http://terryfic.com >> http://WhosComing.com - a simplified, affordable online reservation >> system >> http://TightJacket.com -- stylish protection for your laptop >> -------------------------------------------------------------------------- >> Attitude is the only difference between ordeal and adventure. >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: Tim Benson

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:

quantity minimum problem (1997) Running a store on BOTH http and https (1998) New install permissions (2003) storeBuilder (2002) Line items in table cells (1997) Date calculation problems (1997) Anyone running CommuniGate (2001) WebCat B13 Mac CGI -- Frames question (1997) Flash Stores (2003) database paths/names, and a typo (1997) RE: Upload (1998) WebCatalog/WebMerchant 2.1 (1998) WebCatalog 2.0 b 15 mac (1997) Fun with dates (1997) Table sorting by selected category then others (2004) RE: Credit Card Checksum (1997) Emailer port change (1997) eq (2000) Great product and great job ! (1997) Searching (2004)