We've just pushed a small update today to EZ Exporter to provide an option to select a custom date and time format.

By default, the Shopify API returns the date and time in ISO 8601 format which looks something like this:

2017-03-30T10:38:59-06:00

We recently received a question from a customer asking if there's a way to grab just the month and year. This is actually possible using Calculated Fields, but the formula is a bit complicated, so we decided to provide an option instead of pre-defined date and time formats which we believe are the most common.

To change the default date and time formats for all date/time fields, simply go to Data Settings and you will now see an extra option just below the "Name" field labeled "Date and Time Format." You can then choose from the list of options such as the following:

• YYYY-MM (2017-03)
• YYYY/MM (2017/03)
• MM-YYYY (03-2017)
• MM/YYYY (03/2017)
• YYYY-MM-DD (2017-03-31)
• MM/DD/YYYY (03/31/2017)
• DD/MM/YYYY (31/03/2017)
• YYYY/MM/DD (2017/03/31)
• YYYY-MM-DD hh:mm:ss (2017-03-31 18:30:09)
• MM/DD/YYYY hh:mm AM/PM (03/31/2017 05:30 PM)
• DD/MM/YYYY hh:mm AM/PM (31/03/2017 10:45 AM)
• YYYY/MM/DD hh:mm AM/PM (2017/03/31 01:15 AM)