[Resolved] How to format woocommerce _completed_date hidden custom field

[Author]

Posts

[Nicholas]

Hello I'd like to format the woocommerce _completed_date hidden custom field

Right now the date of the completed order is displayed as such 2018-05-05 13:28:24 and I would like to display it as 05/05/18.

How can I format this date?

Regards,
Nick

[Christian Cox]

The field _completed_date is formatted as a string, so you would have to write custom PHP code to translate that string into a PHP date, then reformat it however you want. I'm not sure how you're displaying it on the front-end, but this is how it could be accomplished on the back-end:

$string = '2018-05-06 21:10:16'; // your _completed_date value
$format = 'm d Y'; // the PHP date format you want to use
$time = strtotime($string);
$date = date( $format, $time);
return $date;

http://php.net/manual/en/function.date.php
http://php.net/manual/en/function.strtotime.php

[Nicholas]

Hello and thank you.

I'd like to use the shortcode in a view that outputs all of the woocommerce orders on the frontend.

So does that mean I'd have to create a custom shortcode?

Best,
Nick

[Christian Cox]

Yes, something like this:

function format_completed_date_func($atts) {
  $a = shortcode_atts( array(
    'format' => 'm d Y',
    'orderid' => 0
  ), $atts );

  $completedDate = get_post_meta( $a['orderid'], '_completed_date', true );
  if ( !$completedDate )
    return;
  $time = strtotime($completedDate);
  $date = date($a['format'], $time);
  return $date;
}

add_shortcode( 'format_completed_date', 'format_completed_date_func');

Then you can use the shortcode in the View's loop like this (replace m/d/Y with the date format of your choice):

[format_completed_date format='m/d/Y' orderid='[wpv-post-id]']

[Nicholas]

Thank you. It works like a charm.