Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › MySQLi Server Behaviors › MySQLI Server Behaviors General / Announcements › Displaying date field from recordset in dd-mm-yyyy format

View all replies to this thread

Displaying date field from recordset in dd-mm-yyyy format

Thread began 8/28/2015 12:18 am by Nathon Jones Web Design | Last modified 8/28/2015 12:17 pm by Nathon Jones Web Design | 1089 views | 3 replies

8/28/2015 12:18 amNathon Jones Web Design

Displaying date field from recordset in dd-mm-yyyy format

We're pulling a date field from our recordset but when it's displayed on the page:
<?php echo($rsEDITPROD->getColumnVal("wbprodDATEDISTILLED")); ?> ...it displays as yyyy-mm-dd.

I've had several goes at resolving it but my PHP knowledge scuppers me yet again:
<?php echo(date_format($rsEDITPROD->getColumnVal("wbprodDATEDISTILLED"),"d-m-Y")); ?>
<?php $date=date_create($rsEDITPROD->getColumnVal("wbprodDATEDISTILLED")); echo date_format($date,"d-m-Y"); ?>

The last one of these works, however when there is no date value for this field it defaults to today's date! :(
Thanks for any advice offered. I will get there eventually...

NJ

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.