Standard Date Format Strings

Labels
AJAX(112) App Studio(7) Apple(1) Application Builder(245) Application Factory(207) ASP.NET(95) ASP.NET 3.5(45) ASP.NET Code Generator(72) ASP.NET Membership(28) Azure(18) Barcode(2) Barcodes(3) BLOB(18) Business Rules(1) Business Rules/Logic(140) BYOD(13) Caching(2) Calendar(5) Charts(29) Cloud(14) Cloud On Time(2) Cloud On Time for Windows 7(2) Code Generator(54) Collaboration(11) command line(1) Conflict Detection(1) Content Management System(12) COT Tools for Excel(26) CRUD(1) Custom Actions(1) Data Aquarium Framework(122) Data Sheet(9) Data Sources(22) Database Lookups(50) Deployment(22) Designer(177) Device(1) DotNetNuke(12) EASE(20) Email(6) Features(101) Firebird(1) Form Builder(14) Globalization and Localization(6) How To(1) Hypermedia(2) Inline Editing(1) Installation(5) JavaScript(20) Kiosk(1) Low Code(3) Mac(1) Many-To-Many(4) Maps(6) Master/Detail(36) Microservices(4) Mobile(63) Mode Builder(3) Model Builder(3) MySQL(10) Native Apps(5) News(18) OAuth(9) OAuth Scopes(1) OAuth2(13) Offline(20) Offline Apps(4) Offline Sync(5) Oracle(11) PKCE(2) Postgre SQL(1) PostgreSQL(2) PWA(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(183) Reports(48) REST(29) RESTful(29) RESTful Workshop(15) RFID tags(1) SaaS(7) Security(81) SharePoint(12) SPA(6) SQL Anywhere(3) SQL Server(26) SSO(1) Stored Procedure(4) Teamwork(15) Tips and Tricks(87) Tools for Excel(2) Touch UI(93) Transactions(5) Tutorials(183) Universal Windows Platform(3) User Interface(338) Video Tutorial(37) Web 2.0(100) Web App Generator(101) Web Application Generator(607) Web Form Builder(40) Web.Config(9) Workflow(28)
Archive
Blog
Monday, June 11, 2012PrintSubscribe
Standard Date Format Strings

A standard date and time format string uses a single format specifier to define the text representation of a date and time value. Any date and time format string that contains more than one character, including white space, is interpreted as a custom date and time format string. A standard or custom format string can be used in two ways:

  • To define the string that results from a formatting operation.

  • To define the text representation of a date and time value that can be converted to a DateTime value by a parsing operation.

Let’s change the Order Date on the Orders controller to display the long date pattern.

Start the Project Designer. In the Project Explorer, double-click on Orders / Fields / OrderDate field node.

OrderDate field on the Orders controller.

Change the Data Format String property:

Property Value
Data Format String D

Press OK to save the field. On the toolbar, press Browse.

Navigate to the Orders page. The Order Date values will be rendered in the long date pattern.

Order Date field values rendered in the long date pattern.

Below is a list of supported date format strings. The format string can be specified either directly or in curly braces. The data format string in the above sample can be written “D” or “{0:D}”.

Format String

Description

Example (Value = 6/15/2009 1:45:30 PM)

"d"

Short date pattern.

6/15/2009 (en-US)
15/06/2009 (fr-FR)
2009/06/15 (ja-JP)

"D"

Long date pattern.

Monday, June 15, 2009 (en-US)
15 июня 2009 г. (ru-RU)
Montag, 15. Juni 2009 (de-DE)

"g" General date/time pattern (short time). 6/15/2009 1:45 PM (en-US)
15/06/2009 13:45 (es-ES)
2009/6/15 13:45 (zh-CN)
"G" General date/time pattern (long time). 6/15/2009 1:45:30 PM (en-US)
15/06/2009 13:45:30 (es-ES)
2009/6/15 13:45:30 (zh-CN)

"t"

Short time pattern.

1:45 PM (en-US)
13:45 (hr-HR)
01:45 م (ar-EG)

"T"

Long time pattern.

1:45:30 PM (en-US)
13:45:30 (hr-HR)
01:45:30 م (ar-EG)

"f"

Full date/time pattern (short time).

Monday, June 15, 2009 1:45 PM (en-US)
den 15 juni 2009 13:45 (sv-SE)
Δευτέρα, 15 Ιουνίου 2009 1:45 μμ (el-GR)

"F"

Full date/time pattern (long time).

Monday, June 15, 2009 1:45:30 PM (en-US)
den 15 juni 2009 13:45:30 (sv-SE)
Δευτέρα, 15 Ιουνίου 2009 1:45:30 μμ (el-GR)

"M", "m"

Month/day pattern.

June 15 (en-US)
15. juni (da-DK)
15 Juni (id-ID)

"s"

Sortable date/time pattern.

2009-06-15T13:45:30

"Y", "y"

Year month pattern.

June, 2009 (en-US)
juni 2009 (da-DK)
Juni 2009 (id-ID)

"U", "u" Universal sortable date/time pattern. 2009-06-15 20:45:30Z