If you are an account admin, you can change the date and time format in your ActiveCampaign account. For example, you can use a MM/DD/YYYY or a DD/MM/YYYY date format. You can also use a 12-hour time format or 24-hour time format. Changing the date and time format will update the date and time display for all users on your account.
In this article, you'll learn how to change the date and time format in your ActiveCampaign account.
Take Note
- Updates to the date and time format will reflect in the following places in your ActiveCampaign account:
- Campaign sent date and time
- Campaign last modified date and time
- Existing custom date fields and more
- Custom date fields on forms will always use a YYYY-MM-DD format regardless of how you've formatted the date and time
- If uploading contacts from a CSV, use a YYYY-MM-DD format for all date fields in your file. Once the file is uploaded, the dates will reflect your preferred format
Change the date and time format
- Click Settings > Advanced.
- Scroll down to the "Date Format" box.
- Click the option you wish to use under "Separate by."
-
Click the date format option you wish to use.
Note that you can create a custom date format by clicking the "Custom date format" option and typing the format you wish to use into the field provided.
As you click different options, the pane on the right will provide a preview of what each format looks like. Learn about supported custom formats. - In the "Time Format" box, click the time format you wish to work with.
You can also create a custom time format by clicking the "Custom time format" option and typing the format you wish to use in the field provided.
As you click different options, the pane on the right will provide a preview of what each format looks like. Learn about supported custom formats. - In the "Date and Time (displayed together)" box, you can create a custom date and time format. The default format for showing the date and time together will already be listed for you. To change this, type the format you wish to use in the field provided.
As you type, the pane on the right will provide a preview of what the format will look like. Learn about supported custom formats.
The "Date and Time" box only applies when both the date and time are displayed together in your ActiveCampaign account. It does not overwrite the selections you made above for date and time independently. - When finished, click the "Save Settings" button.
Custom formats
Below is a list of all date, time, and datetime custom formats supported by ActiveCampaign:
%d // Day of month with leading zeros (01-31)
%a // Weekday name, short
%A // Weekday name, full
%j // Day of year (001-366)
%B // Month name, full
%m // Month (01-12)
%b // Month name, short
%Y // Year with century (2023)
%p // AM/PM
%l // Hour (12-hour clock) [this one is a lower-case L]
%I // Hour (12-hour clock) with leading zeros (01-12) [this one is a capital I]
%H // Hour (24-hour clock) with leading zeros (00-23)
%M // Minute with leading zeros (00-59)
%S // Second with leading zeros (00-59)
%z // UTC offset (+0000)