Hi all-

I'm new to the dynamic side of things, so please bear w/ this simple question...

I've successfully built a mini-cms which sorts news articles based upon the DATE (I have user manually fill in 2002-07-12). Things sort out fine; however, showing a news post as 2002-07-12 is really an unfriendly way - how can I convert those numbers to say July 12, 2002 ?

In dreamweaver select your dynamic text on the page that is displaying the date, goto data bindings panel, data bindings tab select your date scroll across to the right and there is a pull down menu, select date time and there are various formats for displaying dates.

Iain

head hurts, 'mental note to self, stop banging head !'

Is this an ASP only thing as I am unable to see this. All I get are the following and I can't even create a new format. (PHP site)

<img src="www.galleryof3d.com/site/format_list.jpg" border=0>

This is the exact list that appears here.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>In dreamweaver select your dynamic text on the page that is displaying the date, goto data bindings panel, data bindings tab select your date scroll across to the right and there is a pull down menu, select date time and there are various formats for displaying dates.<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

I picked up some extentions that enable date formatting and number formatting w/ php. email me at rob@funktionality and i'll zip'em and reply back.

&lt;font face="Verdana" size="2" color="#666666"&gt;robert
scott rubinoff |web.architect&lt;/font&gt;

No, boy + girls.

The DWMX default date formatting things have a tendency to fuck up the order or format of the date... I seriously wouldn't recommend using it. Ever.

<i><b>NEVER FEAR THOUGH!</b></i>

there is a simple way to do this... use the MySQL date_format syntax:

www.mysql.com/doc/en/Date_and_time_functions.html

this is the only way forward... <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

------------------------
Julio

PHP | MySQL | UD4

ICQ: 19735247

Edited by - poolio on 13 Jan 2003 11:56:06

No, boys + girls.

The DWMX default date formatting things have a tendency to fuck up the order or format of the date... I seriously wouldn't recommend using it. Ever.

<i><b>NEVER FEAR THOUGH!</b></i>

there is a simple way to do this... use the MySQL date_format syntax:

<pre id=code><font face=courier size=2 id=code>
mysql&gt; SELECT DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
-&gt; 'Saturday October 1997'
</font id=code></pre id=code>
more info at:
www.mysql.com/doc/en/Date_and_time_functions.html

this is the only way forward... <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

------------------------
Julio

PHP | MySQL | UD4

ICQ: 19735247

Edited by - poolio on 13 Jan 2003 11:56:06


------------------------
Julio

PHP | MySQL | UD4

ICQ: 19735247

Edited by - poolio on 13 Jan 2003 11:57:39