Is there something wrong with this code ?
Still confused after reading the manual.
td?php echo
$rsJobShortDat-Fields('DATE_FORMAT('LFWJobBank'.'Entered','%m/%d/%Y'));
?/td
Entered is a timestamp column.
With the apostrophes off the table / column I get
errors about unexpected % .
Here is my
Stuart, why not change your select statement (assuming it is correct and
actually works, in and of itself) to give the date-formatted field an
alias:
SELECT
LFWJobBank.JobReferenceCode,DATE_FORMAT(LFWJobBank.Entered,'%m/%d/%Y') AS
date_entered,
LFWJobBank.DazeLeft, LFWJobBank.JobTitle
FROM
Terry , thank you .
The query worked on it's own, but within the PHP it
got thrown back. Alias worked well.
Sorry , sort of new to db / webdev.
Stuart
--- Terry Riley [EMAIL PROTECTED] wrote:
Stuart, why not change your select statement
(assuming it is correct and
actually works, in and