Ok so I had this issue before with CC which I never got resolved, I was not to worried as the project I was working on was only used for myself.
But im now building a database which the end user will want to be able to search and sort by date so I need the data to be stored in yyyy:mm:dd format but would need to be able to display it to the user in the format dd/mm/yyyy
I have tried and tried many ways I found but they dint seem to work (white page of death) or just display the default 01/01/1970
Bob asked me to try:
In CC but it didnt work, and I think it would have changed with C4
i tried
which also does not work.
Do i need to add a statement in the MYSQL box or what do i need to do?
But im now building a database which the end user will want to be able to search and sort by date so I need the data to be stored in yyyy:mm:dd format but would need to be able to display it to the user in the format dd/mm/yyyy
I have tried and tried many ways I found but they dint seem to work (white page of death) or just display the default 01/01/1970
Bob asked me to try:
<?php
$date = strtotime($MyRow->recordtime);
$date = date('m/d/Y', $date);
?>
. . .
<?php echo $date; ?>
In CC but it didnt work, and I think it would have changed with C4
i tried
echo date('Y m d',strtotime($cf_created));
which also does not work.
Do i need to add a statement in the MYSQL box or what do i need to do?