This thread is resolved. Here is a description of the problem and solution.
Problem:
Get the year value of a custom date field using PHP code.
the code i'm using in my test page is:
$post_ID = 1666;
$cld_bd = get_post_meta($post_ID, 'wpcf-child-birth-date', true);
$cld_str_schl_age = get_post_meta($post_ID, 'wpcf-start-school-at-age', true);
$cld_age = floor((time() - $cld_bd)/(365*24*60*60));
$cld_birth_year = date (Y, floor ($cld_bd/(365*24*60*60)));
echo '<p>The BD year for the child is ' . $cld_birth_year . ' age: ' . $cld_age . ' and the start school age is' . $cld_str_schl_age .'</p>';Solution:
I assume the custom field "child-birth-date" is a custom date field created with Types plugin, Types stores time-stamp value into custom date field, so you can get the year from time-stamp value like this:
...
$cld_bd = get_post_meta($post_ID, 'wpcf-child-birth-date', true);
$cld_birth_year = date ('Y', $cld_bd);
...Relevant Documentation:
http://php.net/manual/en/function.date.php
This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.
Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.
| Sun | Mon | Tue | Wed | Thu | Fri | Sat |
|---|---|---|---|---|---|---|
| - | 9:00 – 13:00 | 9:00 – 13:00 | 9:00 – 13:00 | 9:00 – 13:00 | 9:00 – 13:00 | - |
| - | 14:00 – 18:00 | 14:00 – 18:00 | 14:00 – 18:00 | 14:00 – 18:00 | 14:00 – 18:00 | - |
Supporter timezone: Asia/Hong_Kong (GMT+08:00)
This topic contains 5 replies, has 2 voices.
Last updated by 7 years, 1 month ago.
Assisted by: Luo Yang.
I am trying to: get the year of a date using php is offset by multiple years from the date picker year
Link to a page where the issue can be seen:
php code output : hidden link
custom post with selected date for September 9th 2011 : hidden link
I expected to see: the birth year of 2011
Instead, I got: birth year: 1970
i have used similar code on another custom post to calculate user birth year, age, and other calculated values successfully.
when i modify the code to use custom post field of date i get this error for only some years.
when i select in the date picker November 1st 1969 the date year on my test page render correctly (1969)
when i select in the date picker September 9th 2011the date year on my test page render the wrong year (1970)
the code i'm using in my test page is:
$post_ID = 1666; $cld_bd = get_post_meta($post_ID, 'wpcf-child-birth-date', true); $cld_str_schl_age = get_post_meta($post_ID, 'wpcf-start-school-at-age', true); $cld_age = floor((time() - $cld_bd)/(365*24*60*60)); $cld_birth_year = date (Y, floor ($cld_bd/(365*24*60*60))); echo '<p>The BD year for the child is ' . $cld_birth_year . ' age: ' . $cld_age . ' and the start school age is' . $cld_str_schl_age .'</p>';
please advise,
thanks,
David
