LibreOffice 24.2 Help
āĻ¯ā§ āĻā§āĻ¨ āĻ¸ā§āĻā§āĻ°āĻŋāĻ āĻ āĻĨāĻŦāĻž āĻ¸āĻāĻā§āĻ¯āĻžāĻ¸ā§āĻāĻ āĻāĻā§āĻ¸āĻĒā§āĻ°ā§āĻļāĻ¨āĻā§ āĻ¤āĻžāĻ°āĻŋāĻ āĻŽāĻžāĻ¨ā§ āĻ°ā§āĻĒāĻžāĻ¨ā§āĻ¤āĻ¤āĻ° āĻāĻ°āĻž āĻšā§āĨ¤
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 ) 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