I'm having a problem with the way dates are stored when inserting into a date field from a variable.
For instance the date field has been set up as a UK format, dd/mm/yyyy, but when I use a variable which has been set to 05/07/2004, the date when viewed has been switched to 07/05/2004. I'm somewhat puzzled, because if I have a date which is say 19/06/2004 it inserts and views correctly. Also if I manually type this in as 06/19/2004 the field switches it round to what it should be - 19/06/2004.
My regional settings in the control panel are set to English (United Kingdom)
Does anyone have any pointers as to what's going on, or any settings I'm missing?