Hey everyone,
I added a date field to a form and when we are trying to get the value out in SQL we're not getting what we expect. If I just do a select of the field, I get a 7 digit number (2454436). If I try and run the same conversion against it that is run against the date/time fields: convert (varchar(10),dateadd(second, Invoicemonth, '1 January 1970'), 101) 'Invoice Month 1' we get 1/28/1970. I'm no SQL expert- how can I get the value of that field in a MM/DD/YYYY format? Thanks! Chris _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"