Dates before 1900 not displaying correctly

Hi Erin

Are you using the latest version of CMS Builder? I'll do some testing for you to see what's happening but it would best if I do it with the same version as you :).

Let me know and we'll go from there. Thanks!

I am using version 1.27 (just installed within the last couple of weeks). I see that 1.28 just came out last week. Do you recommend that I update it?

Hi Erin,

The problem is some of the PHP functions for converting dates from one format to another don't support dates before 1970.

If the format isn't important you could just show the default date like this (change variable and field names as needed):
Date: <?php echo $record['date'] ?><br/>

And that would show something like this: 1899-02-09 15:00:27

If you need something more we'll need to look into what other PHP date function are available that support older dates. Can you let us know which version of PHP you have and what format you need it displayed in? (or if the default format above works?) Thanks.

Hope that helps!

Thanks for the reply, Dave.

I'm using PHP 5.2.9.9.

I have to admit I don't particularly like just displaying the field as is, especially since the time will always be 00:00:00. There are several date formats that I wouldn't mind using. Currently, I have the format like Dec 31, 1969.

You can view the page here: http://www.soldiersandsailorsmuseum.org/veteran-registry-detail-test.php?Adams-1. On this test page, the first date is the field displayed directly out of the database, and the other two are formatted.

The code I'm using for this is (from the Born heading to the Married heading):
<?php if ($veteran_registryRecord['born'] != '1800-01-01 00:00:00'): ?>
<span id="vetHeading">Born:&nbsp;&nbsp;</span><?php echo $veteran_registryRecord['born'] ?><br />
<?php endif ?>
<?php if ($veteran_registryRecord['died'] != '1800-01-01 00:00:00'): ?>
<span id="vetHeading">Died:&nbsp;&nbsp;</span><?php echo date("M j, Y", strtotime($veteran_registryRecord['died'])) ?><br />
<?php endif ?>
<?php if ($veteran_registryRecord['burial_location']): ?>
<span id="vetHeading">Burial Location:&nbsp;&nbsp;</span><?php echo $veteran_registryRecord['burial_location'] ?><br />
<?php endif ?>
<?php if ($veteran_registryRecord['married_date'] != '1800-01-01 00:00:00'): ?>
<span id="vetHeading">Married:&nbsp;&nbsp;</span>
<?php echo date("M j, Y", strtotime($veteran_registryRecord['married_date'])) ?>
<?php if ($veteran_registryRecord['spouse']): ?> to <?php echo $veteran_registryRecord['spouse'] ?><?php endif ?>
<br />
<?php endif ?>

Thanks, Erin

Hi Erin,

The simplest way to do it is to just write a function to format the mysql date the way you want. Try this one. Add it near the top of the page:

<?php

// return mysql format date "1899-02-09 15:00:27" in this format "Dec 31, 1969"
function formatMysqlDate($mysqlDate) {
list($year, $monthNum, $zeroPaddedDay) = preg_split("/[- ]/", $mysqlDate);
$shortMonthName = date('M', mktime(0,0,0,$monthNum,1));
$longMonthName = date('F', mktime(0,0,0,$monthNum,1));
$dayNum = (int) $zeroPaddedDay;

echo "$shortMonthName $dayNum, $year";
}

?>

You can call it like this:
<?php formatMysqlDate($veteran_registryRecord['born']) ?>

Hope that helps! Let me know if that works for you.

Dave, that is amazing. Works like a charm! You guys are the best.

Thank you, Erin

Hi zick,

The field name shouldn't matter. I believe the above solution should work for you.

Have you tried simply outputting <?php echo $veteran_registryRecord['date'] ?>? Do you get a date like this: 1837-06-21 00:00:00?

What exactly happened when you gave it a try and it didn't work? I'm not sure I understand what a conflict would be.

Chris... you're right, it should for me. I spaced last night and tried placing <?php formatMysqlDate($galleryRecord['date']) ?> on a list page. Obvious where my mistake was now.

So now, I have <?php formatMysqlDate($record['date']) ?> working perfectly on my list page and <?php formatMysqlDate($galleryRecord['date']) ?> works like a charm on my details page.

Thanks!!!!