By default, Windows formats dateswith slashes (3/23/16). However, if you want to use a different format for the date, such as using periods instead of slashes (3.23.16), that’s easy to changein Windows’ settings. You can also change the format of the time.
RELATED: How to Use Periods in Dates in Excel
The format of the date and time affects the clock on the Taskbar, as shown above. It also affects programs you run in Windows, such as Excel, unless you override the format in the program itself. For example, you might want use slashes on the date shown on the Taskbar, but use periods in the dates you enter in Excel.
We’ll show you how to select a different format and how to create a custom format for the date and time in Windows 10, 8.1, and 7. Accessing the basic choices for changing the date and time format is slightly differentin each version of Windows, so we’ll discuss those procedures separately in the first three sections below. However, entering a custom format for the date and time is done the same way in all three Windows versions. So, follow the steps in one of the first three sections, depending on which version of Windows you are using, and then continue with the last section.
As an example in this article, we’ll show you how to change the date format, but changing the time format is a similar process, and we’ll mention where you can do that as well.
How to Access the Date and Time Format Settings in Windows 10
If you’re using Windows 10, click on the Search box or button on the Taskbar. If you don’t see the Search box or button, you can easily enable one or the other.
Type “change the date” in the Search box. Results start to display as you type. Click “Change the date and time format” in the list of results.
On this Change Date and Time Formats settings screen, you can select different formats for the “Short date”, “Long date”, “Short time”, and “Long time”.
You may not see the format you want in the list of options for the date or time. For example, there are various formats using slashes and a couple using dashes, but no dates using periods. You have to access a screen in the old Control Panel to be able to enter a custom date or time format.
To access the screen in the Control Panel that will allow you to enter a custom date or time format, click the back arrow button in the upper-left corner of the Settings screen.
You are returned to the Date & time screen in the Time & Language settings.
Scroll down on the right side of the Date and time screen and click the “Additional date, time, & regional settings” link under Related settings.
The Clock, Language, and Region screen on the Control Panel displays. In the Region section on the right, click the “Change date, time, or number formats” link. This opens the Region dialog box. See the last section of this post for information on how to createa custom date or time format from this menu.
Note that there are other ways of accessing the Control Panel in Windows 10 as well.
How to Access the Date and Time Format Settings in Windows 8.1
If you’re using Windows 8.1, the procedure for changing the format of the date and time is slightly different. To begin, make sure the Start screen is active. If you’re on the desktop, click the “Start” button in the lower-left corner of the screen.
On the Start screen, start typing “change the date” (without the quotes). The Search panel opens and results start to display. When you see “Change the date and time format” appear in the list with the settings icon, click on it.
This screen allows you to select different formats for the short and long date and short and long time. However, as with Windows 10, you are limited in the available choices. If you want to use periods in your dates, you will have to enter a custom date format. We’ll show you how to access the Control Panel screen you need to do this.
To access the Control Panel, we have to go back a couple of screens. So, click the back arrow button in the upper-left corner of the Change date and tine formats screen…
…and again on the Time and language screen.
At the bottom of the left pane on the PC Settings screen, click the “Control Panel” link. Note that there are several different ways you can access the Control Panel in Windows 8/8.1.
On the Control Panel, click the “Change date, time, or number formats” link under Clock, Language, and Region. This opens the Region dialog box, which you will use in the lastsection of this article to customize the date and time format.
How to Access the Date and Time Format Settings in Windows 7
To access the date and time format settings in Windows 7, click the Start menu button and enter “change the date” (without the quotes) into the Search box. Then, click the “Change the date, time, or number format” link in the list of results. This opens the Region dialog box we discuss in the next section. Unlike Windows 10 and 8.1, the Region dialog box is the only place you can select built-in date and time formats.
How to Customize the Date and Time Format in Windows 10, 8.1, and 7
Now, we will set up a custom date using periods. If you’re using Windows 10 or 8.1, the Region dialog box should be open and the Formats tab should be active. If not, click on the “Formats” tab to activate it.Then, click “Additional settings” at the bottom of the tab.
This dialog box also allows you to select built-in date and time formats just like the Change Date and Time Formats screen in PC Settings in Windows 10 and 8.1.
On the Customize Format dialog box, click the “Date” tab.
In the Date formats section, the “Short date” drop-down list box is also an edit box, allowing you to enter a different format. So, type the format you want to use in the “Short date” box. In our example, we entered “M.d.yy”. A small legend displays below the Short date and Long date drop-down lists indicating what the letters used in the date format mean. The “dd” for the day adds a leading zero before single-digit months. You can also use “MM” to add a leading zero before single-digit months, even though that notation is not listed. For the year, “yyyy” uses the full, four-digit year and “yy” uses the last two digits of the year. For example, “MM.dd.yyyy” would display as “03.09.2016”. Once you’ve entered your custom format in the “Short date” box, click “Apply”.
NOTE: The Short date is what’s used to display the date in the notification area on the Taskbar. So, if you want to display a custom long date on the Taskbar, enter the long date you want to use in the “Short date” box, even if it’s one that’s available in the “Long date” drop-down list.
The custom date format you entered displays in the Short date box in the Example section. You can also enter a custom time format by clicking the “Time” tab.
Enter a custom time in the “Short time” box using the notation listed on the dialog box. Once you’ve set up your custom date and time, click “OK” on the Customize Format dialog box.
Click “OK” to close the Region dialog box. If the Control Panel and Settings windows are still open, click the “X” button in the upper-right corner of each window to close them.
Our custom date format with the periods now displays in the notification area of the Taskbar.
Note that when you change the date or time format back to a different format, after entering a custom format, the custom format is not preserved as a choice. You would have to enter it again to change to that custom format.
READ NEXT
- › How to Change Date Formats in Microsoft Excel
- › How to Change the Time on Windows 10
- › How to See (and Delete) Your TikTok Watch History
- › 1Password Wants to Replace Your Password With a “Passkey”
- › Archeology Is Coming to Minecraft
- › Save $300 on Our Favorite Budget TV in Time for the Big Game
- › How to Delete Google Maps History and Recent Searches
- › Windows 11 May Solve a Common Headache With RGB Gaming Gear
FAQs
How do I change the date format to DD MM YYYY in Windows 10? ›
- Go to Clock and Region and click on “Change date, time or number formats”
- Then change your Short date format to the format you want that contains yyyy, MM and dd.
Open Control Panel, and then click Date, Time, Language, and Regional Options. Click Regional and Language Options. On the Regional Options tab, click Customize. On the Date tab, next to Short date format, select a short date format.
How do I change the custom date format in Windows 10? ›Hit the Win key, type “Region”, and choose Region settings. In the Region panel, scroll down and click Change data formats. In the Change data formats, you'll have the option to change the Calendar type, the First day of the week, and options to change the date and time formats.
What is the default format for Date and time? ›Date format is MM/DD/CCYY where MM represents a two-digit month, DD represents a two-digit day of the month, CC represents a two-digit century, and YY represents a two-digit year. The date separator may be one of the following characters: '/', '-' or ','. This is the default date format.
How do I change timestamp to date format? ›- import java.sql.Timestamp;
- import java.util.Date;
- public class TimestampToDateExample1 {
- public static void main(String args[]){
- Timestamp ts=new Timestamp(System.currentTimeMillis());
- Date date=new Date(ts.getTime());
- System.out.println(date);
- }
By default, Microsoft Windows 10 and 11 use dd/mm/yyyy for dates and a 12-hour format for time. This is fine for most people, but you can change the format.
Does DD work on Windows? ›Under the premise that the disk is readable — Windows detects it when you plug the disk or insert the card in the reader — dd for Windows should be able to create a file with about the size of the disk.
How to change date format from mm DD yyyy to DD mm yyyy in windows 11? ›Change Date Format in Customize Format Control Panel
1 Open the Control Panel (icons view), and click/tap on the Region icon. Click/tap on the Date tab. Select the format you want in the Short date and Long date drop menus, or type the custom format you want in the Short date and Long date boxes. Click/tap on OK.
- Right click the Start menu and select Run.
- Type ms-settings:personalization-start and press Enter.
- Uncheck the option Use start full screen.
In Excel, dates are stored as sequential serial numbers. The imported dates are probably stored as a text value, instead of real numbers, and that is causing the formatting problem. Note: Only positive numbers can be formatted as valid dates.
How do I change the data type for a Date? ›
If you just want the Date, you can convert it. Select the Date column, select Home > Transform > Data Type, and then select the Date option.
How to convert date format from dd mm yyyy to dd mm yyyy in Java? ›- import java.text.SimpleDateFormat;
- import java.util.Date;
- public class SimpleDateFormatExample {
- public static void main(String[] args) {
- Date date = new Date();
- SimpleDateFormat formatter = new SimpleDateFormat("dd/MM/yyyy");
- String strDate= formatter.format(date);
- Use the SELECT statement with CONVERT function and date format option for the date values needed.
- To get YYYY-MM-DD use this T-SQL syntax SELECT CONVERT(varchar, getdate(), 23)
- To get MM/DD/YY use this T-SQL syntax SELECT CONVERT(varchar, getdate(), 1)
To set and get the input type date in dd-mm-yyyy format we will use <input> type attribute. The <input> type attribute is used to define a date picker or control field. In this attribute, you can set the range from which day-month-year to which day-month-year date can be selected from.
How do I change the number format in Windows 10? ›- Click the Start button, and then click Control Panel.
- Click Change date, time, or number formats. ...
- On the Formats tab, select the format you want to change from the drop-down list. ...
- Click the tab that contains the settings that you want to modify, and make your changes.
Change Windows 10 Time & Date. To get started, right-click the clock on the taskbar and then click on the Adjust date/time setting on the menu. Then turn off the options to set the time and time zone automatically. If these are enabled, the option to change the date, time, and time zone will be grayed out.
How do I change the format of date format? ›SimpleDateFormat inputFormat = new SimpleDateFormat("dd-MM-yyyy"); SimpleDateFormat outputFormat = new SimpleDateFormat("yyyy-MM-dd"); In this example, the “inputFormat” object is set to the input format of “dd-MM-yyyy”, and the “outputFormat” object is set to the output format of “yyyy-MM-dd”.