This thread is resolved. Here is a description of the problem and solution.
Problem: I would like to calculate the age of a post, in number of days, based on its publish date, and display that number for each post in a View of posts.
Solution: It would require a custom shortcode to calculate the difference between today's date and the post's publish date and display that in a View, something like this:
add_shortcode( 'num-days', 'wpv_num_days_shortcode');
function wpv_num_days_shortcode( $atts ) {
$atts = shortcode_atts( array(
'postid' => ''
), $atts );
$timestamp = get_the_date( 'U', $atts['postid'] );
if( $timestamp != '') {
$age = floor((time() - $timestamp) / ( 60*60*24 )) ;
return $age;
}else {
return 0;
}
}
Then in the front-end the shortcode is like this:
[num-days postid="[wpv-post-id]"]
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 |
|---|---|---|---|---|---|---|
| 8:00 – 12:00 | 8:00 – 12:00 | 8:00 – 12:00 | 8:00 – 12:00 | 8:00 – 12:00 | - | - |
| 13:00 – 17:00 | 13:00 – 17:00 | 13:00 – 17:00 | 13:00 – 17:00 | 13:00 – 17:00 | - | - |
Supporter timezone: America/New_York (GMT-04:00)
This topic contains 22 replies, has 3 voices.
Last updated by 4 years, 11 months ago.
Assisted by: Christian Cox.
I think the most straightforward way is to reuse the View you want to calculate, setting a limit of 1 result and setting the sort order to post date ascending. You can use shortcode attributes or View block attributes to modify the limit and sort order if you don't want to duplicate the original View or create a whole new View just for the oldest age. See the screenshots here, you can see how limit and offset can be implemented in both the blocks builder and the Fields and Views popup in a Classic editor.
Then when you check the View on the front-end, only the 1 oldest result should appear. With a bit of CSS you could hide all the other information and simply show the age alone. Otherwise, you would have to create an entirely separate View just for showing the oldest age from one View.
