Hi....
I'm struggling with a particular problem with dates! I have a form in which the date of completion is added in a text box. with format set to medium date. (dd-mmm-yy) however the date in this text box is being stored as mm/dd/yyyy in the table, so even when the text box on the form reads "01-Jul-10" the data in the table is stored as 07/01/2010.
This knackers up my reporting structure as it then thinks it's the 1st jan! do all my calculations are out......

the code i'm using to get this data from the text box into the table is:


Any help would be much appreciated........ don't know where to go next! (IMG:style_emoticons/default/shrug.gif)

Thanks
Steve

Try changing your update query to use the unambiguous date format of yyyy-mm-dd.

UpdateSQL = "UPDATE TblDPAAction SET TblDPAAction.Updatecomp = [forms]![frmdpaactionupdate].[txtuc], " & _
"TblDPAAction.DTuc = #" & Format( [Forms]![frmdpaactionupdate].[TxtTime],"yyyy-mm-dd") & "#, TblDPAAction.Staffupdatecomp = [forms]![frmunit].[txtusername] " & _
"WHERE (((TblDPAAction.id)=[forms]![frmdpaactionupdate].[txtid]));"
DoCmd.SetWarnings False
DoCmd.RunSQL UpdateSQL
DoCmd.SetWarnings True

For an explanation of what is going on see
International Dates in Access at:
http://allenbrowne.com/ser-36.html

Hooray, that worked! thanks.
I've had a good look through allens stuff too.. thanks for the help.... just need to put the clumps of hair back now!
Steve