Good. Now all you have to do is look at the format mask of your TO_DATE function.

TO_DATE(''2014-09-02'',''YYYY.MM.DD'')

The date string doesn't match the format string.

That's what I thought. I didn't think you could ever store SharePoint data in an Access database....

You're using MS Access as the database to store SharePoint data?

sqldriver (9/2/2014)

---

Ed Wagner (9/2/2014)

---

sqldriver (8/28/2014)

---

The email addresses I was processing were not from a web form, they were provided to us either by clients, or by data marts. Nothing was...

Sean Lange (9/2/2014)

---

Nadrek (9/2/2014)

---

That to me does not look like a viable...

Those are just...

Look at Lynn's corrected query. The REPLACE you're looking for is right there.

sqldriver (8/28/2014)

---

The email addresses I was processing were not from a web form, they were provided to us either by clients, or by data marts. Nothing was deleted, it was...

Think through what columns you want to return and where you're going to start. Consider where the column you need come from and that'll give you what tables you...

If you're building your SQL statement into a variable, you can simply print it out to make sure you have it right. Like Erikur suggested, you'll be safer if...

The only way to be sure is to test. See what columns in your temp table are being used to perform the updates (hopefully a single column), then weigh...

Pasta

Why return everything? Don't you just have to know that a row exists with today's date? All you'd have to return is COUNT(*) or some other single value.

Integrity

Gary Varga (9/2/2014)

---

I would second that. I have yet to visit ANY technical forum,...