I have come up against a strange problem which I can reproduce 100% of the time. We have a number of users with 8.02 (FP1) of which a very small subset have a problem when making any calls to the CDAT function in lotusscript.
Most clients are fine but there are at least two that bring up the error message: ‘Type Mismatch in method DateConvert: STRING found, DATE expected’
This happens when a lotusscript call such as ‘MyVal = Cdat(“19/05/2009”)’ is made.
Obviously, this seems to me like a client configuation issue and would be fixed by a re-install but is this necessary and how can we tell if there are other instances throughout our environment?
Thanks,
Matt
Subject: CDAT() function
Here’s a post from a while back which is similar:http://www.inter-weavers.com/0/RobsBlog.nsf/dx/IsDate.htm
Subject: String Dates
Those clients are probably set-up in US format and that date is not valid in the US since there is no 19th month.
It is far better wherever possible to keep dates as date values and not to hold them as strings.
Had that date been 12th May on that same client, you wouldn’t have got the error but the date would have been interpreted wrongly as 5th December which potentially could have been even worse.
Subject: Many thanks. Resolved
Annoyingly (since I had already checked the regional & language settings), you were correct.
They had set their PC up with UK regional settings but a custom date format (probably left over from a previous user). Anyway, all done now.
Thanks very much for your help.