Posted by Jerry Stuckle on 07/25/06 13:46

Bob Sanderson wrote:
> I have a field in a database called DateRcvd. At present, it outputs in my
> report in the yyyy-mm-dd format. I would like it to display in the dd/mm/yy
> format. What is the easiest way to accomplish this?

Depends on the database., But most have a function to format the
default date to however you want. Check your database documentation.

Otherwise you could reformat it in the php code - use substr() or a
regex to get the year, month and day, then display them like you wish.

Personally I prefer the database function.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]