How can you let coldfusion work with european dates?
I have a form with a text input birthday. I want users to enter a date like dd/mm/yyyy. So in my form page I used #dateformat (birthday, 'dd/mm/yyyy')#.
In my action page I catch it up with
'#dateformat(createodbcdate (birthday), "dd/mm/yyyy"
#' in an update statement. This works if you fill in 18/12/2000 or some day above 12. But if you enter 8/12/2000, it gets confused again and thinks the days are months, and the months are days. Does anybody had the same problem, or know an answer?
I have a form with a text input birthday. I want users to enter a date like dd/mm/yyyy. So in my form page I used #dateformat (birthday, 'dd/mm/yyyy')#.
In my action page I catch it up with
'#dateformat(createodbcdate (birthday), "dd/mm/yyyy"
#' in an update statement. This works if you fill in 18/12/2000 or some day above 12. But if you enter 8/12/2000, it gets confused again and thinks the days are months, and the months are days. Does anybody had the same problem, or know an answer?