Table of contents
TOC
Collapse the table of content
Expand the table of content

DateTimeZone.FromText

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

About

Returns a DateTimeZone value from a set of date formats and culture value.

DateTimeZone.FromText(dateTimeZone as nullable text, optional culture as nullable text) as nullable datetimezone  

Arguments

ArgumentDescription
dateTimeZone
optional cultureA text value corresponding to the culture values supported on your version of Windows, such as "en-US". If the culture is not specified, the current user culture is used. For a list of culture names, see National Language Support (NLS) API Reference.

DateTimeZone formats

  • YYYY-MM-DDThh:mmhh:mm

  • YYYYMMDDThh:mmhh:mm

  • YYYY-MM-DDThh:mm:sshh:mm

  • YYYYMMDDThh:mm:sshh:mm

  • YYYY-MM-DDThh:mm:ss.nnnnnnnhh:mm

  • YYYYMMDDThh:mm:ss.nnnnnnnhh:mm

  • YYYY-MM-DDThh:mm-hh:mm

  • YYYYMMDDThh:mm-hh:mm

  • YYYY-MM-DDThh:mm:ss-hh:mm

  • YYYYMMDDThh:mm:ss-hh:mm

  • YYYY-MM-DDThh:mm:ss.nnnnnnn-hh:mm

  • YYYYMMDDThh:mm:ss.nnnnnnn-hh:mm

  • YYYY-MM-DDThh:mmZ

  • YYYYMMDDThh:mmZ

  • YYYY-MM-DDThh:mm:ssZ

  • YYYYMMDDThh:mm:ssZ

  • YYYY-MM-DDThh:mm:ss.nnnnnnnZ

  • YYYYMMDDThh:mm:ss.nnnnnnnZ

Terms

  • Y = years

  • M = months

  • D = days

  • h = hours

  • m = minutes

  • s = seconds

  • n = fractional seconds

  • TZD = time zone designator

Examples

DateTime.FromText("2010-12-31T01:30:00") equals YYYY-MM-DDThh:mm:ss  
DateTime.FromText("2010-12-31T01:30:00Z") equals 2010-12-31T01:30:00+00:00  
© 2018 Microsoft