I am having problem with inserting the date into the database.
if I force the date to show on the page as mm/dd/yy it will update as dd/mm/yy
but i need to show it on the page as the way is updating dd/mm/yy.
any ideeas?
MM_fieldsStr = "P_Name|value|P_Description|value|supplier|value|s upplier_p_id|value|supplierlogo|value|freeshipping |value|P_Price|value|textfield|value|P_SmallPictur e|value|P_LgPicture|value|P_Discontinued|value|P_O nSpecial|value|P_OnSpecialPrice|value|startdate|va lue|enddate|value|Promo|value|Promo_Start|value|
Pr omo_End|value|CategoryID|value|P_Rated|value"
MM_columnsStr = "P_Name|',none,''|P_Description|',none,''|Supplier ID|',none,''|Supplier_P_ID|',none,''|SupplierLogo| ',none,''|P_FreeShipping|none,1,0|P_Price|none,non e,NULL|P_Weight|',none,''|P_SmallPicture|',none,'' |P_LgPicture|',none,''|P_Discontinued|none,1,0|P_O nSpecial|none,1,0|P_OnSpecialPrice|none,none,NULL| P_DateStart|',none,''|P_DateEnd|',none,''|Promo|no ne,1,0|Promo_Start|',none,''|Promo_End|',none,''|C ategoryID|none,none,NULL|P_Rated|',none,''"
SQL2000 and inserting Date value
