Forums

i have a custom listing and want my date to look like d-m-Y
i've seen other post but for some reason there solutions aint working for me

i have this in my body area:

<?php
$datum = strtotime($row['leskaart.AANSCHAFDATUM']);
$datum = date('d-m-Y', $datum);
?>

<tr>
<td width=30%>{users.username}</td>
<td>{leskaart.INSTRUMENT_NAAM}</td>
<td><?php echo $datum; ?></td>
<td>{leskaart.AANTAL_LESSEN}</td>
</tr>

how ever this shows 1-1-1970 (default date)
i think it does not retrieve the correct value and thus it returns NULL wich will explain the
1-1-1970

any sugestions?

Hi redowl,

The code looks OK.

I suggest that you add a temporary line of code to echo out the value of $row['leskaart.AANSCHAFDATUM'] to see exactly what is there.

Later: just saw this post which may have the answer: $row['leskaart']['AANSCHAFDATUM']

Bob

Hi GrayHead
you are correct (as always 😛 )

$row['leskaart']['AANSCHAFDATUM'] 

is the correct way