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

[WebDNA] Override price in Wd8.5 (2017) Deleting Orders (1997) Re:2nd WebCatalog2 Feature Request (1996) 2.0 Info (1997) WebCat on Intel Core 2 macs anyone? (2007) Need something like [listchars] ... (2000) Setting up WebCatalog with Retail Pro data (1996) Clickable maps and WebCatalog? (1996) Close-to Comparison Code (1998) db security on NT (1997) requiredfields (2002) [OT] Democratic Code (2002) PCS Frames (1997) Snake Bites (1997) Admin Edit prob. (1997) WebDNA with WebStar V (2003) [PHP3] php vs WebCatalog (2000) Re:Email Problem (1997) read and write you own cookies with webcat (1997) Bug Report, maybe (1997)