[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:
Text variables do not show (1999)
Garbage display after 100 records (was WebCatalog usage) (1997)
Re(3): Small Bug: ErrorLog.txt/[FORMVARIABLES]/[ORDERFILE] (1998)
Two submit buttons ? (1997)
WebCatalog for Postcards ? (1997)
Separate SSL Server (1997)
math on date? (1997)
Setting up the server (1997)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
carriage returns in data (1997)
Nav. 4 probs with cart - Serious problem (1997)
No. of items in shopping cart (2000)
Re:Help name our technology! (1997)
Generating unique SKU from [cart] (1997)
range searching (1998)
[sendmail] on NT? (1997)
Upgrading old WebCat Database Files (1997)
HomePage Caution (1997)
Re:Copyright ? (1997)
GuestBook example (1997)