CDate Function

임의의 문자열 또는 숫자 식을 날짜 값으로 변환합니다.

CDate (Expression)

반환 값:

Date

Expression: 변환할 임의의 문자열 또는 숫자 식입니다.

When you convert a string expression, the date and time must be entered either in one of the date acceptance patterns defined for your locale setting (see - Languages and Locales - General) or in ISO date format (momentarily, only the ISO format with hyphens, e.g. "2012-12-31" is accepted). In numeric expressions, values to the left of the decimal represent the date, beginning from December 31, 1899. Values to the right of the decimal represent the time.

  Sub ExampleCDate
      MsgBox cDate(1000.25) ' 09.26.1902 06:00:00
      MsgBox cDate(1001.26) ' 09.27.1902 06:14:24
  End Sub