Re: [WebDNA] Format Days_To_Date
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 100663
interpreted = N
texte = 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:
Associated Messages, from the most recent to the oldest:
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:
Stuart Tremain
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:
RE: Answer: WebDelivery downloads alias, not original ? (1997)
Generating unique SKU from [cart] (1997)
Sorry another test - please ignore (2005)
WebCat2b13MacPlugIn - syntax to convert date (1997)
[SearchString] usage (1997)
WebCat editing, SiteGuard & SiteEdit (1997)
Hiding HTML and page breaks (1997)
More Applescript (1997)
Passing Variable (was How to add product size) (1997)
Multiple Sendmail Tags on One Page (2008)
Forms & Tables (1998)
japanese characters (1997)
Sorting by sku (2001)
[WebDNA] Just drop the Server version (2015)
[ShowNext] (1997)
sort problems....bug or brain fart? (1997)
Mozilla/4. and Browser Info.txt (1997)
RE: shrink-wrapped version out yet? (1997)
Filemaker Pro and [convertchars] (2000)
Date Calulation (1997)