[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:

Clearing cart headers (2000) WebCat2.0 [format thousands .0f] no go (1997) Here's an example of an applet in a tpl (1997) Generating unique SKU from [cart] - FIXED! (1997) WebCatalog 2.0 b 15 mac (1997) WebCat2b12 - nesting [tags] (1997) Adding more than one item and QTY to cart (2000) Order file numbers different than the cart number. why? (2000) WebCat b15 Mac plug-in (1997) Frames and WebCat (1997) Web Delivery Page concept (1997) runtime (2000) serial number (1998) Date Time Oddness (1999) remotely creating and populating a stock inventory db -almost there! (1999) Re1000001: Setting up shop (1997) [searchString] (1997) syntax for contains a word (2002) WebCat2b13 Command Reference Doc error (1997) AppleScript question (1997)