ParseDateTime

Returns a date/time object from a string.

See also LSParseDateTime, IsDate and IsNumericDate.

Syntax

ParseDateTime(date-time-string [, pop-conversion ] )

date-time-string

String being converted to date/time object.

pop-conversion

POP or STANDARD. If you specify POP, the function takes the date/time string passed from a POP mail server and converts it to GMT (Greenwich Mean Time) for the English (US) locale. If you specify STANDARD or nothing, the function provides no conversion. See the Note for more information about parsing date-time strings that are not from the English (US) locale.

Usage

ParseDateTime is similar to CreateDateTime except that it takes a string instead of specifically enumerated date/time values.

Both ParseDateTime and CreateDateTime are provided primarily to increase the readability of code in compound expressions.

Years from 0 to 29 are interpreted as 21^st century values. Years 30 to 99 are interpreted as 20^th century values.

When passing a date/time value as a string, make sure it is enclosed in quotes. Otherwise, it is interpreted as a number representation of a date/time object, returning undesired results.

Note

If the date is formatted for a locale other than the English (US) locale, you need to use the LSParseDateTime() function, then add or subtract the conversion time, depending on the locale. LSParseDateTime does not accept POP dates, nor does it have the capacity to convert dates to Greenwich Mean Time.

Examples

<!--- This example shows the use of ParseDateTime--->
<HTML>
<HEAD>
<TITLE>
ParseDateTime Example
</TITLE>
</HEAD>

<BODY bgcolor=silver>
<H3>ParseDateTime Example</H3>

<CFIF IsDefined("FORM.theTestValue")>
    <CFIF IsDate(FORM.theTestValue)>
    <H3>The expression <CFOUTPUT>#FORM.theTestValue#</CFOUTPUT> 
      is a valid date</H3>
    <P>The date, parsed for use as a date/time value:
      <CFOUTPUT>#ParseDateTime(FORM.theTestValue)#</CFOUTPUT>
...