I found @TextToTime didn’t work correctly on web page after Domino (named server1) was upgraded to 8.5.The string “03-Aug-2009” will be converted to 08-Mar-2009 after @TextToTime(“03-Aug-2009”) runs.
But this issue occurs on some of computers, including my computer.
Wrong converting rules:
The format of date string is DD-MMM-YYYY.
-
If DD<=12, MMM will be converted to day, DD will be converted to month.
-
If DD>12, the converting is right. DD will be converted to day, MMM will be converted to month.
Whatever the regional is changed under control panel on my computer, the issue occurs.
However, whatever the regional is changed on those computer on which @TextToTime runs correctly, the issue won’t occur.
I tested to convert a string like “03-Aug-2009” to date value using other program like asp and java on my computer, they were converted correctly.
I have a test computer with a domino 8.5 (named server2) under my desk. I created a database with a form including @TextToTime formula on that server, and used my computer to visit this form. It, however, worked well. I restarted domino after I changed the regional on the test computer every time, and tested the form. It still worked well. I also added DATEORDER=DMY/MDY/YMD in notes.ini under domino server folder and restarted domino server, it still worked well. I checked the configurations on server1 and server2, and I didn’t find any difference. The only difference is that server1 was upgraded to 8.5 and server2 was installed directly.
Any help, I will appreciate.