Re: [WebDNA] Feature requests - date format

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 104269
interpreted = N
texte =
Oops, I didn't even check. I just was looking at what php has available, and it uses j. I feel that if we are t= o compete with php, we should bring the date format options up to par what php has

Terry


On Mon, 28 Dec 2009 10:22:25 -0500
Ma= tthew Bohne <matthew.bohne@benetela.com> wrote:
> %j is already taken (Day of the year 001-365).
> > Why not %D? It is case sensitive.
>
>
>
> Dan Strong wrote:
>> Not that it spec= ifically solves this, but just to add...
>>I multiply my
>> [date]s by 0 to cleanse them of le= ading zeroes. I also
>>have/had
>> clients that fixate(d) on this. Agreed that a built-in
&= gt;> "non-leading-zero" specifier (%j works for me) would be
>>nice.
>> -Dan
>>
>&g= t;
>> 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=3D 0&rep= lace=3D ]
>>> > [Format Days_To_Date %A, %B %d,
>>> >%Y][math]{[eventdate]}[/math][/Format]
= >>> > [/grep]
>>> >
>>> > - chris
>>> >
>>> &g= t; 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
>>> >>
>&= gt;> >> [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
>>> >&g= t;to get January 1, 2010
>>> >>
>>> >> [format days_to_date
>>> &g= t;>%A][math]{[eventdate]}[/math][/format], [format
>>> >>days_to_date %b][math]{[eventdate]}[/math= ][/format]
>>> >>[math][format days_to_date
>>> >>%d][math]{[eve= ntdate]}[/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 dis= play dates all the time on web pages, and it
>>>just
>>> >>looks awful to show a leadin= g zero in a written out
>>>date.
>>> >>Customers also complain abo= ut it, they really do.
>>> >>
>>> >> This what is currently available:
&g= t;>> >>
>>> >> %a....: Abbreviated weekday name "Wed"
>>> >> %A....: F= ull 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 o= f week
>>> >> %w....: Weekday 0 (Sunday) - 6 (Saturday)
>>> >> %W....: Week # of year= , Monday first day of week
>>> >> %x....: Date as Sep 11 2008
>>> >> %X....: Tim= e as 14:01:12
>>> >> %y....: Year without century 00-99
>>> >> %Y....: Year with cen= tury 1900-2199
>>> >> %z....: offset of server
>>> >> %Z....: Time zone of server
= >>> >> %%....: %
>>> >>
>>> >> I propose adding %j for day of month wi= thout leading
>>>0.
>>> >>PHP also has one for the month without the leading
>>&g= t;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 b= ring WebDNA up to parity with php.
>>> >>
>>> >> Terry
>>&= gt; >>
>>> >>> Better yet, write a function and call it date. That
>>> >&= gt;>will overwrite
>>> >>> the native method within pages using that function.
>&= gt;> >>> Plus there's one
>>> >>> less keyword to remember.
>>>= ; >>>
>>> >>> Bill
>>> >>>
>>> >>> On Thu, De= c 24, 2009 at 1:14 PM, Donovan Brooke
>>> >>><dbrooke@webdna.us> wrote:
&g= t;>> >>>> Terry Wilson wrote:
>>> >>>>>
>>> >>>&= gt;> 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.
>&= gt;>Currently I
>>> >>>>>jump through hoops
>>> >>>>&g= t; splitting the date up and using [math] to make
>>>this
>>> >>>>>happen.
= >>> >>>>>
>>> >>>>> Terry
>>> >>>>
>>&g= t; >>>>
>>> >>>> you could write a function, then call that..
>>= > >>>>
>>> >>>> [cleandate [date]]
>>> >>>>
&= gt;>> >>>> Donovan
>>> >>>>
>>> >>>>=
>>> >>>>
>>> >>>> --
>>> >>>> Donovan Brooke
&g= t;>> >>>> WebDNA Software Corporation
>>> >>>> http://www.webdna.us
>= >> >>>> **[Square Bracket Utopia]**
>>> >>>>
>>>--------------= -------------------------------------------
>>> >>>> This message is sent to you because you are
>>= >subscribed
>>> >>>>to
>>> >>>> the mailing list <= talk@webdna.us>.
>>> >>>> To unsubscribe, E-mail to: <talk-leave@webdna.us><= br>>>> >>>> archives: http://mail.webdna.us/list/talk@webdna.us
>>> >>>>= ; old archives: http://dev.webdna.us/TalkListArchive/
>>> >>>> Bug Reporting:
>>> >>>>http://fo= rum.webdna.us/eucabb.html?page=3Dtopics&category=3D288
>>>= ; >>>>
>>> >>>
>>>-----------= ----------------------------------------------
>>> >>> This message is sent to you because you are
>>>= subscribed
>>> >>>to
>>> >>> the mailing list <talk@web= dna.us>.
>>> >>> To unsubscribe, E-mail to: <talk-leave@webdna.us>
>>> >= >> archives: http://mail.webdna.us/list/talk@webdna.us
>>> >>> ol= d archives: http://dev.webdna.us/TalkListArchive/
>>> >>> Bug Reporting:
>>> >>>http://forum.webd= na.us/eucabb.html?page=3Dtopics&category=3D288
>>> >>
>>> >> --
>>> >> Terry Wilso= n | terry@terryfic.com |
>>>http://terryfic.com
>>> >> http://WhosC= oming.com - a simplified, affordable
>>>online
>>> >>reservation system
>= >> >> http://TightJacket.com -- stylish protection for your
>>> >>laptop
>>>= ; >>
>>> -------------------------------------------------------------------------= -
>>> >> Attitude is the only difference between ordeal and
>>> >>adventure.
>&= gt;> >>
>>>----------------------------------------= -----------------
>>> >> This message is sent to you because you are
>>>subs= cribed
>>> >>to
>>> >> the mailing list <talk@webdna.us&g= t;.
>>> >> To unsubscribe, E-mail to: <talk-leave@webdna.us>
>>> >> archives= : http://mail.webdna.us/list/talk@webdna.us
>>> >> old archives: http://dev.webdna.us/TalkListArchive/
>>&= gt; >> Bug Reporting:
>>> >>http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D2= 88
>>> >
>>> >
>>>---------------------------------------------------------=
>>> > This message is sent to you because you are subscribed
>>> >to
>>> >= ; the mailing list <talk@webdna.us>.
>>> > To unsubscribe, E-mail to: &= lt;talk-leave@webdna.us>
>>> > 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=3Dtopics&= ;category=3D288
>>>
>>>
>>
>>
>> --
>> -Dan Strong
>= > http://www.DanStrong.com
>
> ---------------------------------------------------------
> This me= ssage is sent to you because you are subscribed
>to
> the mailing list <talk@webdna.us>.
> To un= subscribe, E-mail to: <talk-leave@webdna.us>
> 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=3Dtopics&category=3D288

=A0=
Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Feature requests - date format (Dan Strong 2009)
  2. Re: [WebDNA] Feature requests - date format ("Terry Wilson" 2009)
  3. Re: [WebDNA] Feature requests - date format ("Terry Wilson" 2009)
  4. Re: [WebDNA] Feature requests - date format (Dan Strong 2009)
  5. Re: [WebDNA] Feature requests - date format (Matthew Bohne 2009)
  6. Re: [WebDNA] Feature requests - date format (Dan Strong 2009)
  7. Re: [WebDNA] Feature requests - date format ("Terry Wilson" 2009)
  8. Re: [WebDNA] Feature requests - date format (christophe.billiottet@webdna.us 2009)
  9. Re: [WebDNA] Feature requests - date format (Terry Wilson 2009)
  10. Re: [WebDNA] Feature requests - date format (William DeVaul 2009)
  11. Re: [WebDNA] Feature requests - date format (Donovan Brooke 2009)
  12. [WebDNA] Feature requests - date format (Terry Wilson 2009)
Oops, I didn't even check. I just was looking at what php has available, and it uses j. I feel that if we are t= o compete with php, we should bring the date format options up to par what php has

Terry


On Mon, 28 Dec 2009 10:22:25 -0500
Ma= tthew Bohne <matthew.bohne@benetela.com> wrote:
> %j is already taken (Day of the year 001-365).
> > Why not %D? It is case sensitive.
>
>
>
> Dan Strong wrote:
>> Not that it spec= ifically solves this, but just to add...
>>I multiply my
>> [date]s by 0 to cleanse them of le= ading zeroes. I also
>>have/had
>> clients that fixate(d) on this. Agreed that a built-in
&= gt;> "non-leading-zero" specifier (%j works for me) would be
>>nice.
>> -Dan
>>
>&g= t;
>> 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=3D 0&rep= lace=3D ]
>>> > [Format Days_To_Date %A, %B %d,
>>> >%Y][math]{[eventdate]}[/math][/Format]
= >>> > [/grep]
>>> >
>>> > - chris
>>> >
>>> &g= t; 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
>>> >>
>&= gt;> >> [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
>>> >&g= t;to get January 1, 2010
>>> >>
>>> >> [format days_to_date
>>> &g= t;>%A][math]{[eventdate]}[/math][/format], [format
>>> >>days_to_date %b][math]{[eventdate]}[/math= ][/format]
>>> >>[math][format days_to_date
>>> >>%d][math]{[eve= ntdate]}[/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 dis= play dates all the time on web pages, and it
>>>just
>>> >>looks awful to show a leadin= g zero in a written out
>>>date.
>>> >>Customers also complain abo= ut it, they really do.
>>> >>
>>> >> This what is currently available:
&g= t;>> >>
>>> >> %a....: Abbreviated weekday name "Wed"
>>> >> %A....: F= ull 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 o= f week
>>> >> %w....: Weekday 0 (Sunday) - 6 (Saturday)
>>> >> %W....: Week # of year= , Monday first day of week
>>> >> %x....: Date as Sep 11 2008
>>> >> %X....: Tim= e as 14:01:12
>>> >> %y....: Year without century 00-99
>>> >> %Y....: Year with cen= tury 1900-2199
>>> >> %z....: offset of server
>>> >> %Z....: Time zone of server
= >>> >> %%....: %
>>> >>
>>> >> I propose adding %j for day of month wi= thout leading
>>>0.
>>> >>PHP also has one for the month without the leading
>>&g= t;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 b= ring WebDNA up to parity with php.
>>> >>
>>> >> Terry
>>&= gt; >>
>>> >>> Better yet, write a function and call it date. That
>>> >&= gt;>will overwrite
>>> >>> the native method within pages using that function.
>&= gt;> >>> Plus there's one
>>> >>> less keyword to remember.
>>>= ; >>>
>>> >>> Bill
>>> >>>
>>> >>> On Thu, De= c 24, 2009 at 1:14 PM, Donovan Brooke
>>> >>><dbrooke@webdna.us> wrote:
&g= t;>> >>>> Terry Wilson wrote:
>>> >>>>>
>>> >>>&= gt;> 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.
>&= gt;>Currently I
>>> >>>>>jump through hoops
>>> >>>>&g= t; splitting the date up and using [math] to make
>>>this
>>> >>>>>happen.
= >>> >>>>>
>>> >>>>> Terry
>>> >>>>
>>&g= t; >>>>
>>> >>>> you could write a function, then call that..
>>= > >>>>
>>> >>>> [cleandate [date]]
>>> >>>>
&= gt;>> >>>> Donovan
>>> >>>>
>>> >>>>=
>>> >>>>
>>> >>>> --
>>> >>>> Donovan Brooke
&g= t;>> >>>> WebDNA Software Corporation
>>> >>>> http://www.webdna.us
>= >> >>>> **[Square Bracket Utopia]**
>>> >>>>
>>>--------------= -------------------------------------------
>>> >>>> This message is sent to you because you are
>>= >subscribed
>>> >>>>to
>>> >>>> the mailing list <= talk@webdna.us>.
>>> >>>> To unsubscribe, E-mail to: <talk-leave@webdna.us><= br>>>> >>>> archives: http://mail.webdna.us/list/talk@webdna.us
>>> >>>>= ; old archives: http://dev.webdna.us/TalkListArchive/
>>> >>>> Bug Reporting:
>>> >>>>http://fo= rum.webdna.us/eucabb.html?page=3Dtopics&category=3D288
>>>= ; >>>>
>>> >>>
>>>-----------= ----------------------------------------------
>>> >>> This message is sent to you because you are
>>>= subscribed
>>> >>>to
>>> >>> the mailing list <talk@web= dna.us>.
>>> >>> To unsubscribe, E-mail to: <talk-leave@webdna.us>
>>> >= >> archives: http://mail.webdna.us/list/talk@webdna.us
>>> >>> ol= d archives: http://dev.webdna.us/TalkListArchive/
>>> >>> Bug Reporting:
>>> >>>http://forum.webd= na.us/eucabb.html?page=3Dtopics&category=3D288
>>> >>
>>> >> --
>>> >> Terry Wilso= n | terry@terryfic.com |
>>>http://terryfic.com
>>> >> http://WhosC= oming.com - a simplified, affordable
>>>online
>>> >>reservation system
>= >> >> http://TightJacket.com -- stylish protection for your
>>> >>laptop
>>>= ; >>
>>> -------------------------------------------------------------------------= -
>>> >> Attitude is the only difference between ordeal and
>>> >>adventure.
>&= gt;> >>
>>>----------------------------------------= -----------------
>>> >> This message is sent to you because you are
>>>subs= cribed
>>> >>to
>>> >> the mailing list <talk@webdna.us&g= t;.
>>> >> To unsubscribe, E-mail to: <talk-leave@webdna.us>
>>> >> archives= : http://mail.webdna.us/list/talk@webdna.us
>>> >> old archives: http://dev.webdna.us/TalkListArchive/
>>&= gt; >> Bug Reporting:
>>> >>http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D2= 88
>>> >
>>> >
>>>---------------------------------------------------------=
>>> > This message is sent to you because you are subscribed
>>> >to
>>> >= ; the mailing list <talk@webdna.us>.
>>> > To unsubscribe, E-mail to: &= lt;talk-leave@webdna.us>
>>> > 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=3Dtopics&= ;category=3D288
>>>
>>>
>>
>>
>> --
>> -Dan Strong
>= > http://www.DanStrong.com
>
> ---------------------------------------------------------
> This me= ssage is sent to you because you are subscribed
>to
> the mailing list <talk@webdna.us>.
> To un= subscribe, E-mail to: <talk-leave@webdna.us>
> 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=3Dtopics&category=3D288

=A0=
"Terry Wilson"

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:

Extracting a filename (2004) Webcat and other cgi (2000) nested showif? (1998) Protecting Images (2003) Emailer setup (1997) WebCat for mass emailings (1997) The future of WebCatalog is coming with 4.0... (2000) [searchString] (1997) Artwork (1997) Database Updates (1997) did I miss anything (1997) [WriteFile] problems (1997) Add a Blog to your site. (2002) international time (1997) Checkboxes (1997) [WebDNA] Use of MySQL with WebDNA (2010) show if date < expiry date (2002) [OT] Google Info (2004) Documentation Feedback (1997) Requiring that certain fields be completed (1997)