[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 anage as of a certain date. I used the %y as the age. At least until sometimethis spring when it stopped working. Oh well. Thanks for the comments.-timOn 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 anage as of a certain date. I used the %y as the age. At least until sometimethis spring when it stopped working. Oh well. Thanks for the comments.-timOn 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)