I have an application using Cold Fusion flash forms where the user selects the date with the flash calendar and the application stores the date in text format in the database. When I have to do date calculations I use the cdate() function to convert to date.
In one out of every few hundred transactions, the text field in the database is filled with NaN/NaN/NaN rather than the date. When the cdate() function finds this, I get the expected error (invalid date or time string) or (data type mismatch).
Has anyone else had this experience where randomly and rarely the datefield calendar outputs NaN/NaN/NaN to the text field in the database rather than the date? Any thoguhts or suggestions would be appreciated.