- Date Format Creator 1 2 – Date Format Creator Microsoft Free
- Date Format Creator 1 2 – Date Format Creator Microsoft Teams
- Date Format Creator 1 2 – Date Format Creator Microsoft Office 2010
In the options/general menu, select 'W04-4' in the date format: Then the start and finish dates will be displayed with the week number and day of the week (ie 6 for friday). You cold also create a custom field with a formula using the ProjDateConv function with the pjDateWwwdd format option. This example shows how to format date and time in custom formats using Java SimpleDateFormat class.
In this post, we'll examine custom format codes that allow you to get your date values formatted exactly as desired. This post is inspired by Sidney, who asked how to change date formats in Excel.
Format Cells
To change the format of a date value, select the cell and then open the Format Cells dialog box.
Note: This post assumes that the cell value is recognized by Excel as a valid date and is not entered as a text string.
Tidy up 5 2 1 download free. The Format Cells dialog box can be opened by using the following ribbon icon:
- Home > Format > Format Cells
Date Format Creator 1 2 – Date Format Creator Microsoft Free
A keyboard alternative is Ctrl+1.
The resulting Format Cells dialog is displayed below.
When you select Date from the Category list on the left, you'll see that there are many built-in format types for dates. If the one you want is shown, simply select it and click OK.
Custom Date Codes
But, the more powerful and flexible formatting options are available when you select Custom from the Category list as shown below.
There are many built-in custom formats that you can select from the list, or, you can enter a custom format code into the Type field. When you enter a custom format code, you have great flexibility in how you display the month, day, and year. For example, if you want the show the month name fully spelled out, you would use code mmmm. If you want to show the month as a three-letter abbreviation, you would use code mmm. Here is a list of the custom date format codes and their result.
In our case, we'd like to show the month as a three-letter abbreviation, then a dash, and then the four-digit year. So, we enter mmm-yyyy as shown.
The resulting format is shown below.
As you can see, the custom format codes enable you to get the date formatted as desired.
If you have any other cool custom format tricks, please share by posting a comment below…thanks!
Additional Resources
Date Format Creator 1 2 – Date Format Creator Microsoft Teams
- Blog post: Custom date format with TEXT
| RunAsDate v1.37 - Run a program with the specified date/time Copyright (c) 2007 - 2019 Nir Sofer |
See Also
- AdvancedRun - Run application as system user or without elevation or as user of another process or with specific environment variables.
- NirCmd - Do many useful tasks from command-line, without displaying any user interface.
Description
RunAsDate is a small utility that allows you to run a program in the date and time that you specify.This utility doesn't change the current system date and time of your computer, but it only injects the date/time that you specify into the desired application.You can run multiple applications simultaneously, each application works with different date and time,while the real date/time of your system continues to run normally.
How does it work ?
RunAsDate intercepts the kernel API calls that returns the current date and time (GetSystemTime, GetLocalTime, GetSystemTimeAsFileTime, NtQuerySystemTime, GetSystemTimePreciseAsFileTime), and replaces the current date/time with the date/time that you specify.System Requirements
RunAsDate works under Windows 2000, Windows XP, Windows Server 2003, Windows Server 2008, Windows Vista, Windows 7, Windows 8, and Windows 10.Older versions of Windows are not supported. There is also x64 version available in a separated download, for using with x64 applications.Important Notice !!
I get many email messages that say something like 'I tried to extend the trial period of xyz software with RunAsDate and it didn't work'.Running a software with different date/time can be used for many legitimate purposes and for these purposes RunAsDate was created.I have never said implicitly or explicitly that RunAsDate can be used for extending the trial period of a software.For some shareware programs, RunAsDate might really work, but many shareware creators are smart enough to detect that the date/time was modified and when they detect the time change, they end the trial period immediately.
Please don't bother yourself to send me a question about extending the trial period of a software, because these kind of messages are simply deleted without answering.
Versions History
- Version 1.37:
- Fixed bug: RunAsDate failed to work properly when using the 32-bit and the 64-bit versions in the same time.
- Also, the DLL file of RunAsDate is now deleted automatically when you close the main window of RunAsDate (If it's not locked).
- Version 1.36:
- Added 'Run As Administrator' button to easily run RunAsDate as Administrator. You have to run RunAsDate as Administrator when the program you want to run with RunAsDate requires elevation.
- Version 1.35:
- RunAsDate now displays an error message if you try to run 32-bit program with 64-bit version of RunAsDate or 64-bit program with 32-bit version of RunAsDate.
- RunAsDate now displays an error message if it fails to run the specified .exe file.
- RunAsDate now also intercepts the NtQuerySystemTime and GetSystemTimePreciseAsFileTime API functions.
- RunAsDate now also intercepts the date/time functions on kernelbase.dll (in addition to kernel32.dll). This change solves the issue with cmd.exe on Windows 10 (it uses the APIs on kernelbase.dll )
- Version 1.31:
- Fixed bug: When a program executed with RunAsDate requested to get the current time in GMT (GetSystemTime and GetSystemTimeAsFileTime API), RunAsDate provided the wrong time with a difference of one hour if the computer date was in summer (With daylight saving time) but the selectedRunAsDate date was in winter (Without daylight saving time) and vice versa..
- Version 1.30:
- Added option to set the date/time relative to the current time.You can add (positive number) or subtract (negative number) the following time units: seconds, minutes, hours, days, months, and years.
- Added 'Start in folder' option.
- RunAsDate now saves the last settings to config file (RunAsDate.cfg)
- Version 1.21:
- Fixed bug with 'Move the time forward according to the real time' option: After around 7 minutes from the time that the application was started,RunAsDate failed to calculate the time properly.
- Version 1.20:
- Added 'Return to the current date/time after xx seconds' option.
- Version 1.16:
- Fixed bug: RunAsDate removed a quote character when using it in the {Program parameters} section of the command-line string.
- Version 1.15:
- Fixed RunAsDate to work properly on Windows 8 64-bit.
- Version 1.11:
- Added Drag & Drop support: You can now choose the .exe file to run by dragging it from Explorer into the main window of RunAsDate.
- Version 1.10:
- Added auto complete support in the filename field.
- Added x64 version.
- Version 1.05:
- Fixed bug: When using 'Create Desktop Shortcut', the /immediate and /movetime options were not added to the shortcut's command-line
- Version 1.04:
- The main dialog-box is now resizable.
- Version 1.03:
- Added 'Immediate Mode' - Change the date immediately when the program starts.
- Version 1.02:
- New option: Move the time forward according to the real time.
- Version 1.01:
- New option: Create a shortcut on your desktop that will run a program with the date/time that you specify.
- When you don't specify the time in the command-line, the current time will be used, instead of 00:00:00.
- Version 1.00 - First release.
Using RunAsDate
RunAsDate doesn't require any installation process or additional DLL files.In order to start using it, simply copy the executable file (RunAsDate.exe) to any folder you like, and run it.In the main window of RunAsDate, select the desired date and time and the application that you want to run.Optionally, you can also specify the command-line parameters to run the program. Press the 'Run' button to start the application with the specified date/time.
Immediate Mode
In versions prior to 1.03, RunAsDate always waited until the kernel was fully loaded, and only theninjected the desired date/time.This mean that some programs that get the date/time im very early stage, received the real current date/time,instead of the fake date/time of RunAsDate. Starting from version 1.03, when the 'Immediate Mode' is turned on, RunAsDate inject the date/timeimmediately when the process starts, without waiting to the kernel loading.However, this mode can also cause troubles to some applications, especially if they were written in .NETIf executing an application from RunAsDate cause it to crash, you should turn off the 'Immediate Mode'.
Using RunAsDate from Command-Line
You can also use RunAsDate from command-line, with the following syntax:RunAsDate.exe {/immediate} {/movetime} {/startin [folder]} {/returntime [seconds] } [ddmmyyyy] {hh:mm:ss} [Program to run] {Program parameters}
Examples:
RunAsDate.exe 22102002 12:35:22 'C:Program FilesMicrosoft OfficeOFFICE11OUTLOOK.EXE'
RunAsDate.exe 14022005 'c:tempmyprogram.exe' param1 param2
RunAsDate.exe /movetime 11082004 16:21:42 'C:Program FilesMicrosoft OfficeOFFICE11OUTLOOK.EXE'
RunAsDate.exe /movetime /returntime 15 10122001 11:41:26 'c:tempmyprogram.exe'
RunAsDate.exe Hours:-10 'C:Program FilesMicrosoft OfficeOFFICE11OUTLOOK.EXE'
RunAsDate Limitations
- RunAsDate will not affect applications that take the current date/time from another source.For example: application that loads the current date from remote server.
Date Format Creator 1 2 – Date Format Creator Microsoft Office 2010
Translating RunAsDate To Another Language
RunAsDate allows you to easily translate all dialog-boxes and other stringsto other languages.In order to do that, follow the instructions below:
- Run RunAsDate with /savelangfile parameter:
RunAsDate.exe /savelangfile
A file named RunAsDate_lng.ini will be created in the folder of RunAsDate utility. - Open the created language file in Notepad or in any other text editor.
- Translate the dialog-boxes and string entries to the desired language.
- After you finish the translation, Run RunAsDate, and all translated strings will be loaded from the language file.
If you want to run RunAsDate without the translation, simply rename the language file, or move it to another folder.
License
This utility is released as freeware. You are allowed to freely distribute this utility via floppy disk, CD-ROM, Internet, or in any other way, as long as you don't charge anything for this. If you distribute this utility, you must include all files inthe distribution package, without any modification !Be aware that selling this utility as a part of a software package is not allowed !
Disclaimer
Note: This post assumes that the cell value is recognized by Excel as a valid date and is not entered as a text string.
Tidy up 5 2 1 download free. The Format Cells dialog box can be opened by using the following ribbon icon:
- Home > Format > Format Cells
Date Format Creator 1 2 – Date Format Creator Microsoft Free
A keyboard alternative is Ctrl+1.
The resulting Format Cells dialog is displayed below.
When you select Date from the Category list on the left, you'll see that there are many built-in format types for dates. If the one you want is shown, simply select it and click OK.
Custom Date Codes
But, the more powerful and flexible formatting options are available when you select Custom from the Category list as shown below.
There are many built-in custom formats that you can select from the list, or, you can enter a custom format code into the Type field. When you enter a custom format code, you have great flexibility in how you display the month, day, and year. For example, if you want the show the month name fully spelled out, you would use code mmmm. If you want to show the month as a three-letter abbreviation, you would use code mmm. Here is a list of the custom date format codes and their result.
In our case, we'd like to show the month as a three-letter abbreviation, then a dash, and then the four-digit year. So, we enter mmm-yyyy as shown.
The resulting format is shown below.
As you can see, the custom format codes enable you to get the date formatted as desired.
If you have any other cool custom format tricks, please share by posting a comment below…thanks!
Additional Resources
Date Format Creator 1 2 – Date Format Creator Microsoft Teams
- Blog post: Custom date format with TEXT
| RunAsDate v1.37 - Run a program with the specified date/time Copyright (c) 2007 - 2019 Nir Sofer |
See Also
- AdvancedRun - Run application as system user or without elevation or as user of another process or with specific environment variables.
- NirCmd - Do many useful tasks from command-line, without displaying any user interface.
Description
RunAsDate is a small utility that allows you to run a program in the date and time that you specify.This utility doesn't change the current system date and time of your computer, but it only injects the date/time that you specify into the desired application.You can run multiple applications simultaneously, each application works with different date and time,while the real date/time of your system continues to run normally.
How does it work ?
RunAsDate intercepts the kernel API calls that returns the current date and time (GetSystemTime, GetLocalTime, GetSystemTimeAsFileTime, NtQuerySystemTime, GetSystemTimePreciseAsFileTime), and replaces the current date/time with the date/time that you specify.System Requirements
RunAsDate works under Windows 2000, Windows XP, Windows Server 2003, Windows Server 2008, Windows Vista, Windows 7, Windows 8, and Windows 10.Older versions of Windows are not supported. There is also x64 version available in a separated download, for using with x64 applications.Important Notice !!
I get many email messages that say something like 'I tried to extend the trial period of xyz software with RunAsDate and it didn't work'.Running a software with different date/time can be used for many legitimate purposes and for these purposes RunAsDate was created.I have never said implicitly or explicitly that RunAsDate can be used for extending the trial period of a software.For some shareware programs, RunAsDate might really work, but many shareware creators are smart enough to detect that the date/time was modified and when they detect the time change, they end the trial period immediately.
Please don't bother yourself to send me a question about extending the trial period of a software, because these kind of messages are simply deleted without answering.
Versions History
- Version 1.37:
- Fixed bug: RunAsDate failed to work properly when using the 32-bit and the 64-bit versions in the same time.
- Also, the DLL file of RunAsDate is now deleted automatically when you close the main window of RunAsDate (If it's not locked).
- Version 1.36:
- Added 'Run As Administrator' button to easily run RunAsDate as Administrator. You have to run RunAsDate as Administrator when the program you want to run with RunAsDate requires elevation.
- Version 1.35:
- RunAsDate now displays an error message if you try to run 32-bit program with 64-bit version of RunAsDate or 64-bit program with 32-bit version of RunAsDate.
- RunAsDate now displays an error message if it fails to run the specified .exe file.
- RunAsDate now also intercepts the NtQuerySystemTime and GetSystemTimePreciseAsFileTime API functions.
- RunAsDate now also intercepts the date/time functions on kernelbase.dll (in addition to kernel32.dll). This change solves the issue with cmd.exe on Windows 10 (it uses the APIs on kernelbase.dll )
- Version 1.31:
- Fixed bug: When a program executed with RunAsDate requested to get the current time in GMT (GetSystemTime and GetSystemTimeAsFileTime API), RunAsDate provided the wrong time with a difference of one hour if the computer date was in summer (With daylight saving time) but the selectedRunAsDate date was in winter (Without daylight saving time) and vice versa..
- Version 1.30:
- Added option to set the date/time relative to the current time.You can add (positive number) or subtract (negative number) the following time units: seconds, minutes, hours, days, months, and years.
- Added 'Start in folder' option.
- RunAsDate now saves the last settings to config file (RunAsDate.cfg)
- Version 1.21:
- Fixed bug with 'Move the time forward according to the real time' option: After around 7 minutes from the time that the application was started,RunAsDate failed to calculate the time properly.
- Version 1.20:
- Added 'Return to the current date/time after xx seconds' option.
- Version 1.16:
- Fixed bug: RunAsDate removed a quote character when using it in the {Program parameters} section of the command-line string.
- Version 1.15:
- Fixed RunAsDate to work properly on Windows 8 64-bit.
- Version 1.11:
- Added Drag & Drop support: You can now choose the .exe file to run by dragging it from Explorer into the main window of RunAsDate.
- Version 1.10:
- Added auto complete support in the filename field.
- Added x64 version.
- Version 1.05:
- Fixed bug: When using 'Create Desktop Shortcut', the /immediate and /movetime options were not added to the shortcut's command-line
- Version 1.04:
- The main dialog-box is now resizable.
- Version 1.03:
- Added 'Immediate Mode' - Change the date immediately when the program starts.
- Version 1.02:
- New option: Move the time forward according to the real time.
- Version 1.01:
- New option: Create a shortcut on your desktop that will run a program with the date/time that you specify.
- When you don't specify the time in the command-line, the current time will be used, instead of 00:00:00.
- Version 1.00 - First release.
Using RunAsDate
RunAsDate doesn't require any installation process or additional DLL files.In order to start using it, simply copy the executable file (RunAsDate.exe) to any folder you like, and run it.In the main window of RunAsDate, select the desired date and time and the application that you want to run.Optionally, you can also specify the command-line parameters to run the program. Press the 'Run' button to start the application with the specified date/time.
Immediate Mode
In versions prior to 1.03, RunAsDate always waited until the kernel was fully loaded, and only theninjected the desired date/time.This mean that some programs that get the date/time im very early stage, received the real current date/time,instead of the fake date/time of RunAsDate. Starting from version 1.03, when the 'Immediate Mode' is turned on, RunAsDate inject the date/timeimmediately when the process starts, without waiting to the kernel loading.However, this mode can also cause troubles to some applications, especially if they were written in .NETIf executing an application from RunAsDate cause it to crash, you should turn off the 'Immediate Mode'.
Using RunAsDate from Command-Line
You can also use RunAsDate from command-line, with the following syntax:RunAsDate.exe {/immediate} {/movetime} {/startin [folder]} {/returntime [seconds] } [ddmmyyyy] {hh:mm:ss} [Program to run] {Program parameters}
Examples:
RunAsDate.exe 22102002 12:35:22 'C:Program FilesMicrosoft OfficeOFFICE11OUTLOOK.EXE'
RunAsDate.exe 14022005 'c:tempmyprogram.exe' param1 param2
RunAsDate.exe /movetime 11082004 16:21:42 'C:Program FilesMicrosoft OfficeOFFICE11OUTLOOK.EXE'
RunAsDate.exe /movetime /returntime 15 10122001 11:41:26 'c:tempmyprogram.exe'
RunAsDate.exe Hours:-10 'C:Program FilesMicrosoft OfficeOFFICE11OUTLOOK.EXE'
RunAsDate Limitations
- RunAsDate will not affect applications that take the current date/time from another source.For example: application that loads the current date from remote server.
Date Format Creator 1 2 – Date Format Creator Microsoft Office 2010
Translating RunAsDate To Another Language
RunAsDate allows you to easily translate all dialog-boxes and other stringsto other languages.In order to do that, follow the instructions below:
- Run RunAsDate with /savelangfile parameter:
RunAsDate.exe /savelangfile
A file named RunAsDate_lng.ini will be created in the folder of RunAsDate utility. - Open the created language file in Notepad or in any other text editor.
- Translate the dialog-boxes and string entries to the desired language.
- After you finish the translation, Run RunAsDate, and all translated strings will be loaded from the language file.
If you want to run RunAsDate without the translation, simply rename the language file, or move it to another folder.
License
This utility is released as freeware. You are allowed to freely distribute this utility via floppy disk, CD-ROM, Internet, or in any other way, as long as you don't charge anything for this. If you distribute this utility, you must include all files inthe distribution package, without any modification !Be aware that selling this utility as a part of a software package is not allowed !
Disclaimer
The software is provided 'AS IS' without any warranty, either expressed or implied,including, but not limited to, the implied warranties of merchantability and fitnessfor a particular purpose. The author will not be liable for any special, incidental,consequential or indirect damages due to loss of data or any other reason.Feedback
If you have any problem, suggestion, comment, or you found a bug in my utility, you can send a message to nirsofer@yahoo.com.Don't send me any question or request about extending the trial period of a software, this kind of message is simply deleted without answering.
| Download RunAsDate |
| Download RunAsDate for x64 |
RunAsDate is also available in other languages. In order to change the language of RunAsDate, download the appropriate language zip file, extract the 'runasdate_lng.ini', and put it in the same folder that you Installed RunAsDate utility.
| Language | Translated By | Date | Version |
|---|---|---|---|
| Filipino | Paolo Rodriguez | 07/11/2013 | 1.0.0.201311061300 |
| Afrikaans | Bezman | 26/12/2011 | 1.0 |
| Arabic | ماجد الحسين Magid Hussein | 02/10/2007 | |
| Bosnian | Max | 19/06/2010 | 1.10 |
| Brazilian Portuguese | Paulo Guzmán | 30/03/2013 | 1.16 |
| Bulgarian | Георги Цветанов | 16/07/2017 | 1.35 |
| Czech | Milan Malý | 02/07/2019 | 1.37 |
| Dutch | Jan Verheijen | 03/04/2019 | 1.37 |
| Dutch | Dutch - by Egbert van den Bosch | 03/01/2010 | 1.0 |
| Farsi | PDN | 06/11/2009 | |
| Finnish | Olli | 22/10/2007 | |
| French | Eric FICHOT | 10/10/2014 | 1.30 |
| French | https://www.leblogduhacker.fr | 23/04/2019 | 1.37 |
| Galician | Xosé Antón Vicente Rodríguez | 07/04/2008 | |
| German | «Latino» auf WinTotal.de | 25/03/2019 | 1.37 |
| Greek | geogeo.gr | 15/12/2017 | 1.36 |
| Greek | Βασίλης Κοσμίδης (SkyHi) | 31/12/2008 | |
| Hungarian | La_Valse | 22/11/2018 | 1.36 |
| Italian | BubuXP | 31/03/2020 | 1.37 |
| Italian | theReAcE | 11/01/2017 | 1.31 |
| Japanese | coolz | 20/03/2016 | 1.30 |
| Latvian | Nizaury | 07/02/2011 | |
| Lithuanian | Gintarmixas | 26/03/2013 | |
| Polish | Netgrafik Design | 08/11/2015 | |
| Portuguese | Neliton P. | 10/05/2008 | |
| Portuguese Brasil | Cristiano Prates | 18/10/2008 | |
| Romanian | Jaff (Oprea Nicolae) | 05/02/2016 | 1.30 |
| Romanian | Jaff (Oprea Nicolae) | 08/12/2011 | 1.11 |
| Russian | Dmitry Yerokhin | 19/11/2018 | 1.36 |
| Simplified Chinese | ZXH | 12/10/2016 | 1.31 |
| Simplified Chinese | phantasy.leo | 20/10/2017 | 1.35 |
| Simplified Chinese | syshut | 09/01/2018 | 1.36 |
| Serbian | Vladimirom Zrnicem | 17/05/2015 | 1.30 |
| Slovak | František Fico | 26/03/2019 | 1.37 |
| Slovenian | Erik Klavora | 15/03/2008 | |
| Spanish | Mr. Brazzi | 26/11/2013 | 1.21 |
| Spanish | NewAge | 22/03/2016 | 1.30 |
| Swedish | Göran Helsingborg | 10/07/2019 | 1.31 |
| Traditional Chinese | Danfong Hsieh | 17/01/2018 | 1.36 |
| Thai | E b o k | 24/11/2008 | 1.05 |
| Turkish | Berk Yenal | 24/04/2019 | |
| Valencian | vjatv | 22/06/2009 | 1.10 |
| Vietnamese | Bùi Nguyễn Phương Duy | 14/01/2015 |
