Hi DNG,
I know i probably been a bit dim but i tried this as i thought Format must be a sQL command:
[code]
INSERT INTO offer(OfferCode, OfferPercent, OfferStartDate, OfferFinishDate, OfferDescription) VALUES ('24082005-174507',1, Format(04/08/2005 17:45:07, dd-mm-yyyy hh:nn:ss)...