This code: Sub TestDateLiteral MsgBox TypeName(#2025-09-26#) End Sub unexpectedly produces "Double" instead of "Date". The problem was discussed in https://gerrit.libreoffice.org/c/core/+/36002, where support for date literals was implemented for bug 93727. The problem there was in NextSym(); at that time, no solution was found for keeping the type of parsed literal, so SbxDOUBLE was assigned. I mark this "implementationError", but "implementationDefect" would fit better IMO.
https://gerrit.libreoffice.org/c/core/+/191555
Mike Kaganski committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/22d7827c6695358e11ee06a5599b72a92ff0b2ac tdf#168569: support date values in string pool It will be available in 26.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Mike Kaganski committed a patch related to this issue. It has been pushed to "libreoffice-25-8": https://git.libreoffice.org/core/commit/3d7003a7c1010ba50cb6442f407d2560d9aaf26a tdf#168569: support date values in string pool It will be available in 25.8.3. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Mike Kaganski committed a patch related to this issue. It has been pushed to "libreoffice-25-8-2": https://git.libreoffice.org/core/commit/141585c001780bd1e9c580198c1fe17d604aae05 tdf#168569: support date values in string pool It will be available in 25.8.2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.