Re: [WebDNA] Feature requests - date format
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 104268
interpreted = N
texte = That it is, that it is... also, I mistyped and said I multiply by 0... I actually multiply by 1. But I'm sure you all know what I meant because you probably do the same thing. -- -Dan Strong http://www.DanStrong.com On 12/28/2009 7:22 AM, Matthew Bohne wrote: > %j is already taken (Day of the year 001-365). > > Why not %D? It is case sensitive. > > > > Dan Strong wrote: >> Not that it specifically solves this, but just to add... I multiply >> my [date]s by 0 to cleanse them of leading zeroes. I also have/had >> clients that fixate(d) on this. Agreed that a built-in >> "non-leading-zero" specifier (%j works for me) would be nice. >> -Dan >> >> >> On 12/26/2009 5:45 PM, Terry Wilson wrote: >>> Nice workaround, Chris! >>> >>> >>> On Sat, 26 Dec 2009 23:21:07 -0200 >>> christophe.billiottet@webdna.us wrote: >>> > what about >>> > >>> > [grep search= 0&replace= ] >>> > [Format Days_To_Date %A, %B %d, >>> >%Y][math]{[eventdate]}[/math][/Format] >>> > [/grep] >>> > >>> > - chris >>> > >>> > On Dec 26, 2009, at 23:02, Terry Wilson wrote: >>> > >>> >> You guys are missing the point. I'm talking about >>> >>formatting a date field such as >>> >> >>> >> [Format Days_To_Date %A, %B %d, >>> >>%Y][math]{[eventdate]}[/math][/Format] >>> >> >>> >> Currently, something like the above looks like >>> >> >>> >> Friday, January 01, 2010 -- ugly! So I have to do this >>> >>to get January 1, 2010 >>> >> >>> >> [format days_to_date >>> >>%A][math]{[eventdate]}[/math][/format], [format >>> >>days_to_date %b][math]{[eventdate]}[/math][/format] >>> >>[math][format days_to_date >>> >>%d][math]{[eventdate]}[/math][/format][/math], [format >>> >>days_to_date %Y][math]{[eventdate]}[/math][/format] >>> >> >>> >> (It performs math on the day portion to turn it into an >>> >>integer.) >>> >> >>> >> I display dates all the time on web pages, and it just >>> >>looks awful to show a leading zero in a written out date. >>> >>Customers also complain about it, they really do. >>> >> >>> >> This what is currently available: >>> >> >>> >> %a....: Abbreviated weekday name "Wed" >>> >> %A....: Full weekday name "Wednesday" >>> >> %b....: Abbreviated month name "Feb" >>> >> %B....: Full month name "February" >>> >> %c....: Date and time "Wed Sep 19 18:24:21 2010" >>> >> %d....: Day of month 01-31 >>> >> %H....: Hour 00-23 >>> >> %I....: Hour 01-12 >>> >> %j....: Day of year 001-365 >>> >> %m....: Month 01-12 >>> >> %M....: Minute 00-59 >>> >> %p....: AM or PM >>> >> %S....: Seconds 00-59 >>> >> %U....: Week # of year, Sunday first day of week >>> >> %w....: Weekday 0 (Sunday) - 6 (Saturday) >>> >> %W....: Week # of year, Monday first day of week >>> >> %x....: Date as Sep 11 2008 >>> >> %X....: Time as 14:01:12 >>> >> %y....: Year without century 00-99 >>> >> %Y....: Year with century 1900-2199 >>> >> %z....: offset of server >>> >> %Z....: Time zone of server >>> >> %%....: % >>> >> >>> >> I propose adding %j for day of month without leading 0. >>> >>PHP also has one for the month without the leading zero >>> >>and a bunch of other formats, like the number of days in >>> >>a month. It would great to add all these formats present >>> >>in php to bring WebDNA up to parity with php. >>> >> >>> >> Terry >>> >> >>> >>> Better yet, write a function and call it date. That >>> >>>will overwrite >>> >>> the native method within pages using that function. >>> >>> Plus there's one >>> >>> less keyword to remember. >>> >>> >>> >>> Bill >>> >>> >>> >>> On Thu, Dec 24, 2009 at 1:14 PM, Donovan Brooke >>> >>>
wrote: >>> >>>> Terry Wilson wrote: >>> >>>>> >>> >>>>> How about a date format that does not have the leading >>> >>>>>zero? i.e., like d, >>> >>>>> but without the zeroes, like the j in php. Currently I >>> >>>>>jump through hoops >>> >>>>> splitting the date up and using [math] to make this >>> >>>>>happen. >>> >>>>> >>> >>>>> Terry >>> >>>> >>> >>>> >>> >>>> you could write a function, then call that.. >>> >>>> >>> >>>> [cleandate [date]] >>> >>>> >>> >>>> Donovan >>> >>>> >>> >>>> >>> >>>> >>> >>>> -- >>> >>>> Donovan Brooke >>> >>>> WebDNA Software Corporation >>> >>>> http://www.webdna.us >>> >>>> **[Square Bracket Utopia]** >>> >>>> --------------------------------------------------------- >>> >>>> This message is sent to you because you are subscribed >>> >>>>to >>> >>>> the mailing list . >>> >>>> To unsubscribe, E-mail to: >>> >>>> archives: http://mail.webdna.us/list/talk@webdna.us >>> >>>> old archives: http://dev.webdna.us/TalkListArchive/ >>> >>>> Bug Reporting: >>> >>>>http://forum.webdna.us/eucabb.html?page=topics&category=288 >>> >>>> >>> >>> --------------------------------------------------------- >>> >>> This message is sent to you because you are subscribed >>> >>>to >>> >>> the mailing list . >>> >>> To unsubscribe, E-mail to: >>> >>> archives: http://mail.webdna.us/list/talk@webdna.us >>> >>> old archives: http://dev.webdna.us/TalkListArchive/ >>> >>> Bug Reporting: >>> >>>http://forum.webdna.us/eucabb.html?page=topics&category=288 >>> >> >>> >> -- >>> >> 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: >>> >> archives: http://mail.webdna.us/list/talk@webdna.us >>> >> old archives: http://dev.webdna.us/TalkListArchive/ >>> >> Bug Reporting: >>> >>http://forum.webdna.us/eucabb.html?page=topics&category=288 >>> > >>> > --------------------------------------------------------- >>> > This message is sent to you because you are subscribed >>> >to >>> > the mailing list . >>> > To unsubscribe, E-mail to: >>> > archives: http://mail.webdna.us/list/talk@webdna.us >>> > old archives: http://dev.webdna.us/TalkListArchive/ >>> > Bug Reporting: >>> >http://forum.webdna.us/eucabb.html?page=topics&category=288 >>> >>> >> >> >> -- >> -Dan Strong >> http://www.DanStrong.com > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: > http://forum.webdna.us/eucabb.html?page=topics&category=288
Associated Messages, from the most recent to the oldest:
That it is, that it is... also, I mistyped and said I multiply by 0... I actually multiply by 1. But I'm sure you all know what I meant because you probably do the same thing. -- -Dan Strong http://www.DanStrong.com On 12/28/2009 7:22 AM, Matthew Bohne wrote: > %j is already taken (Day of the year 001-365). > > Why not %D? It is case sensitive. > > > > Dan Strong wrote: >> Not that it specifically solves this, but just to add... I multiply >> my [date]s by 0 to cleanse them of leading zeroes. I also have/had >> clients that fixate(d) on this. Agreed that a built-in >> "non-leading-zero" specifier (%j works for me) would be nice. >> -Dan >> >> >> On 12/26/2009 5:45 PM, Terry Wilson wrote: >>> Nice workaround, Chris! >>> >>> >>> On Sat, 26 Dec 2009 23:21:07 -0200 >>> christophe.billiottet@webdna.us wrote: >>> > what about >>> > >>> > [grep search= 0&replace= ] >>> > [Format Days_To_Date %A, %B %d, >>> >%Y][math]{[eventdate]}[/math][/Format] >>> > [/grep] >>> > >>> > - chris >>> > >>> > On Dec 26, 2009, at 23:02, Terry Wilson wrote: >>> > >>> >> You guys are missing the point. I'm talking about >>> >>formatting a date field such as >>> >> >>> >> [Format Days_To_Date %A, %B %d, >>> >>%Y][math]{[eventdate]}[/math][/Format] >>> >> >>> >> Currently, something like the above looks like >>> >> >>> >> Friday, January 01, 2010 -- ugly! So I have to do this >>> >>to get January 1, 2010 >>> >> >>> >> [format days_to_date >>> >>%A][math]{[eventdate]}[/math][/format], [format >>> >>days_to_date %b][math]{[eventdate]}[/math][/format] >>> >>[math][format days_to_date >>> >>%d][math]{[eventdate]}[/math][/format][/math], [format >>> >>days_to_date %Y][math]{[eventdate]}[/math][/format] >>> >> >>> >> (It performs math on the day portion to turn it into an >>> >>integer.) >>> >> >>> >> I display dates all the time on web pages, and it just >>> >>looks awful to show a leading zero in a written out date. >>> >>Customers also complain about it, they really do. >>> >> >>> >> This what is currently available: >>> >> >>> >> %a....: Abbreviated weekday name "Wed" >>> >> %A....: Full weekday name "Wednesday" >>> >> %b....: Abbreviated month name "Feb" >>> >> %B....: Full month name "February" >>> >> %c....: Date and time "Wed Sep 19 18:24:21 2010" >>> >> %d....: Day of month 01-31 >>> >> %H....: Hour 00-23 >>> >> %I....: Hour 01-12 >>> >> %j....: Day of year 001-365 >>> >> %m....: Month 01-12 >>> >> %M....: Minute 00-59 >>> >> %p....: AM or PM >>> >> %S....: Seconds 00-59 >>> >> %U....: Week # of year, Sunday first day of week >>> >> %w....: Weekday 0 (Sunday) - 6 (Saturday) >>> >> %W....: Week # of year, Monday first day of week >>> >> %x....: Date as Sep 11 2008 >>> >> %X....: Time as 14:01:12 >>> >> %y....: Year without century 00-99 >>> >> %Y....: Year with century 1900-2199 >>> >> %z....: offset of server >>> >> %Z....: Time zone of server >>> >> %%....: % >>> >> >>> >> I propose adding %j for day of month without leading 0. >>> >>PHP also has one for the month without the leading zero >>> >>and a bunch of other formats, like the number of days in >>> >>a month. It would great to add all these formats present >>> >>in php to bring WebDNA up to parity with php. >>> >> >>> >> Terry >>> >> >>> >>> Better yet, write a function and call it date. That >>> >>>will overwrite >>> >>> the native method within pages using that function. >>> >>> Plus there's one >>> >>> less keyword to remember. >>> >>> >>> >>> Bill >>> >>> >>> >>> On Thu, Dec 24, 2009 at 1:14 PM, Donovan Brooke >>> >>> wrote: >>> >>>> Terry Wilson wrote: >>> >>>>> >>> >>>>> How about a date format that does not have the leading >>> >>>>>zero? i.e., like d, >>> >>>>> but without the zeroes, like the j in php. Currently I >>> >>>>>jump through hoops >>> >>>>> splitting the date up and using [math] to make this >>> >>>>>happen. >>> >>>>> >>> >>>>> Terry >>> >>>> >>> >>>> >>> >>>> you could write a function, then call that.. >>> >>>> >>> >>>> [cleandate [date]] >>> >>>> >>> >>>> Donovan >>> >>>> >>> >>>> >>> >>>> >>> >>>> -- >>> >>>> Donovan Brooke >>> >>>> WebDNA Software Corporation >>> >>>> http://www.webdna.us >>> >>>> **[Square Bracket Utopia]** >>> >>>> --------------------------------------------------------- >>> >>>> This message is sent to you because you are subscribed >>> >>>>to >>> >>>> the mailing list . >>> >>>> To unsubscribe, E-mail to: >>> >>>> archives: http://mail.webdna.us/list/talk@webdna.us >>> >>>> old archives: http://dev.webdna.us/TalkListArchive/ >>> >>>> Bug Reporting: >>> >>>>http://forum.webdna.us/eucabb.html?page=topics&category=288 >>> >>>> >>> >>> --------------------------------------------------------- >>> >>> This message is sent to you because you are subscribed >>> >>>to >>> >>> the mailing list . >>> >>> To unsubscribe, E-mail to: >>> >>> archives: http://mail.webdna.us/list/talk@webdna.us >>> >>> old archives: http://dev.webdna.us/TalkListArchive/ >>> >>> Bug Reporting: >>> >>>http://forum.webdna.us/eucabb.html?page=topics&category=288 >>> >> >>> >> -- >>> >> 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: >>> >> archives: http://mail.webdna.us/list/talk@webdna.us >>> >> old archives: http://dev.webdna.us/TalkListArchive/ >>> >> Bug Reporting: >>> >>http://forum.webdna.us/eucabb.html?page=topics&category=288 >>> > >>> > --------------------------------------------------------- >>> > This message is sent to you because you are subscribed >>> >to >>> > the mailing list . >>> > To unsubscribe, E-mail to: >>> > archives: http://mail.webdna.us/list/talk@webdna.us >>> > old archives: http://dev.webdna.us/TalkListArchive/ >>> > Bug Reporting: >>> >http://forum.webdna.us/eucabb.html?page=topics&category=288 >>> >>> >> >> >> -- >> -Dan Strong >> http://www.DanStrong.com > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: > http://forum.webdna.us/eucabb.html?page=topics&category=288
Dan Strong
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:
Math Context (2001)
WebCat2: Items xx to xx shown, etc. (1997)
PSC recommends what date format yr 2000??? (1997)
All choices on IE different than Netscape (1997)
Date sorting (1997)
Shownext! (1998)
Suffix Mapping (1997)
[WebDNA] WebDNA slow processing (2011)
possible, WebCat2.0 and checkboxes-restated (1997)
Separate SSL Server (1997)
Where's Cart Created ? (1997)
A workaround for handling date range search in yyyy/mm/dd form (1997)
post (2000)
Price and Formula.db (2002)
Is the list server working? (1998)
f2 download problems (1997)
carriage returns in data (1997)
More on the email templates (1997)
Emailer or [sendmail] questions ... (1998)
WebCat2b12--[searchstring] bug (1997)