CDateToIso Function

Returns the date in ISO format without separators (YYYYMMDD) from a serial date number that is generated by the DateSerial or the DateValue or the CDateFromIso function.

The year part consists of at least four digits, with leading zeros if the absolute value is less than 1000, it can be negative with a leading minus sign if the date passed denotes a year before the common era (BCE) and it can have more than four digits if the absolute value is greater than 9999. The formatted string returned can be in the range "-327680101" to "327671231".

แžšแžผแž”โ€‹แžแŸ†แžŽแžถแž„โ€‹แž…แŸ†แžŽแžถแŸ†

Years less than 100 and greater than 9999 are supported since LibreOffice 5.4.


แžœแžถแž€แŸ’แž™โ€‹แžŸแž˜แŸ’แž–แž“แŸ’แž’ แŸ–


CDateToIso(Number)

แžแž˜แŸ’แž›แŸƒโ€‹แžแŸ’แžšแžกแž”แŸ‹ แŸ–

แžแŸ’แžŸแŸ‚โ€‹แžขแž€แŸ’แžŸแžš

แž”แŸ‰แžถแžšแŸ‰แžถแž˜แŸ‰แŸ‚แžแŸ’แžš แŸ–

แž…แŸ†แž“แžฝแž“โ€‹ แŸ– แž…แŸ†แž“แžฝแž“โ€‹แž‚แžแŸ‹โ€‹แžŠแŸ‚แž›โ€‹แž˜แžถแž“โ€‹แž›แŸแžโ€‹แžŸแž˜แŸ’แž‚แžถแž›แŸ‹โ€‹แž€แžถแž›โ€‹แž”แžšแžทแž…แŸ’แž†แŸแž‘ย แŸ”

Error codes:

5 แž€แžถแžšโ€‹แž แŸ…โ€‹แž”แŸ‚แž”แž”แž‘โ€‹แž˜แžทแž“โ€‹แžแŸ’แžšแžนแž˜แžแŸ’แžšแžผแžœ

แžงแž‘แžถแž แžšแžŽแŸ แŸ–


Sub ExampleCDateToIso
    MsgBox "" & CDateToIso(Now) ,64,"ISO Date"
End Sub