20 May
2022
20 May
'22
11:45 a.m.
On 5/20/22 14:25, Robert Wilhelm wrote:
This doesn't work for string arguments, e.g. CDate("1").
Thanks. Seems CDate("1/2/2000") works, but for CDate("1") I get type mismatch from VariantChangeType. I will try to improve my patch.
Maybe this could be an alternate path if VT_DATE conversion fails, doing arg -> R8 -> DATE.