I have read up a bit on that article as well as some others regarding conversions of varchars to date time, but i am still missing a peice of the...

Jeff,

I beleive that would be two months since it is calculating it in days correct?

so not just 1 calendar months difference. or am i backward? 🙂

Hey guys, update to this question... blech so many changes to my data. 🙁

[original service date]

20070630 ...

WOOT! thanks to both of you for your assistance!

here is what i am using.

I dropped the original timestamp from the view and replaced with this.

CASE WHEN IsDate(dbo.[PCS Data...

Thank you both for the solution, I may not have included enough information.

both fields are in the same table with 64k records and i am creating a view...

Thanks for all the help everyone, i am going to do some looking and im sure ill hit this thread again with more questions. 🙂

GilaMonster (1/9/2009)

---

JPLeBlanc (1/9/2009)

---

It looks and feels fairly simple but each time i do this i get an import error. It finds the data but from what i remember without...

Matt Miller (1/9/2009)

---

Assuming the incoming file format lends itself to it, you could go "old school" and use BCP. It's fairly easy to automate, so that you just have...

Ughhh... I was afraid that would be the answer...

Thanks for the assistance! 🙂 it is much appreciated.

Almost perfect! thanks! except that will provide the time right now. I was trying to avoid this as i am always working with the prior day, and sometimes i...