Build Date Text For Free

__DATE__ The compilation date of the current source file. The date is a constant length string literal of the form Mmm dd yyyy. The month name Mmm is the same as the abbreviated month name generated by the C Runtime Library (CRT) asctime function.

The calendar date on which a given version of an application is built (compiled, linked, etc.) and is often stamped into the application itself, which can then be read at runtime.

__DATE__ is a preprocessor macro that expands to current date (at compile time) in the form mmm dd yyyy (e.g. "Jan 14 2012"), as a string. The __DATE__ macro can be used to provide information about the particular moment a binary was built. You can also use the __TIME__ macro to get the current time.

Make sure you have a Resources folder in your project. Add this statement to pre-build event command line: echo %date% %time% > "$(ProjectDir)\Resources\BuildDate.txt" Run a build (creates the BuildDate.txt file) and then add that file as a resource. Access the file method in your c# class.

Convert text dates by using the DATEVALUE function Enter =DATEVALUE( Click the cell that contains the text-formatted date that you want to convert. Enter ) Press ENTER, and the DATEVALUE function returns the serial number of the date that is represented by the text date. What is an Excel serial number?

Select all of the dates you want to convert and press Ctrl+C to copy them. Open Notepad or any other text editor, and paste the copied dates there. Notepad automatically converts the dates to the text format. Press Ctrl+A to select all text strings, and then Ctrl+C to copy them.

Creating a custom date format in Excel In an Excel sheet, select the cells you want to format. Press Ctrl+1 to open the Format Cells dialog. On the Number tab, select Custom from the Category list and type the date format you want in the Type box. Click OK to save the changes.