Formatting of Time and Date

  • On the order results page, the formatting for Date and Time looks like this…

    2018-11-21T09:30

    I would much prefer a more organized formatting like…

    11-21-2018 – 9:30am

    Can this be accomplished?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor etoilewebdesign

    (@etoilewebdesign)

    Hi st1x80,

    You can go to the “Options” –> “Basic” tab in your plugin admin panel and change the “Date/Time Format” to “European (DD-MM–YY)”. Also make sure that you have set the WordPress time zone in the correct format by going to the “Settings” –> “General” tab in your WordPress.

    Thread Starter st1x80

    (@st1x80)

    This does not solve either of my issues.

    I want MM-DD-YY and that is not an option from your plugin.

    2nd I asked for a formatting that comes out in this format on the tracking side.

    11/21/18 09:00AM

    Currently your plugin does this

    21/11/18T09:00 which is terrible to use with customers.

    Thread Starter st1x80

    (@st1x80)

    BTW, This issue is only a problem with the custom date fields.

    Example from the Order Status page.

    Measure Date: 2018-11-21T09:30
    Order Date: 2018-11-24

    Order Status Order Updated
    Product Ordered 2018-11-24 18:40:51

    MySQL Entry for Product Ordered Status Update “2018-11-24 18:40:51”
    MySQL Entry for Order Date(Custom Field) “2018-11-21T09:30”

    I figured out the reason why. You have all custom fields being input into the DB as “text” for the Meta Value but when we update one of the standard fields you have it going into the DB as “datetime”.

    Can we get custom fields to have their own individual columns that take the correct input format as you have done with all of your prebuilt fields? Fields specifically for “datetime” instead of only “text”?

    • This reply was modified 5 years, 11 months ago by st1x80.
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Formatting of Time and Date’ is closed to new replies.

Tags