have you tried using the #'s before and after the date? Alex Elger Micronage Ltd [EMAIL PROTECTED]
-----Original Message----- From: Nick Middleweek [mailto:[EMAIL PROTECTED]] Sent: 02 August 2002 3:58 PM To: ActiveServerPages Subject: RE: Problems with UPDATE ? - Dates? - FORMATTING? Thanks for your reply Tore, It's sorted now, I found a KB article... http://support.microsoft.com/default.aspx?scid=kb;EN-US;q175168 and sent that to my hosting company. They acted quickly, impressed. I am having a nightmare though with dates. I have a text area that someone types in the date "07/08/2002". When it gets saved into Access it seems to get changed to "08/07/2002". Although if I orginally typed in "31/08/2002", then the date stays as is. Are there any ways to force the dates to stay in a particular format? Thanks, Nick :> -----Original Message----- :> For SQL Server: :> :> UPDATE Items :> SET Name = 'Squeeky toy', :> FK_User = 12, :> Description = 'blue and white spider', :> Starting_Bid = 4, :> Bid_Increment = 1, :> Image_URL = 'http://localhost/bwe/jon.gif', :> Expires = CONVERT(DateTime, '23/08/2002', 101), :> Active = True :> WHERE Items.PK_ID=1 :> :> HTH, :> Tore. --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
