Thanks both, in the end what worked was changing the language on the actual report and that fixed my formatting.

I will test again next Monday but I have no doubt...

Sorry foe the delay, I was out last Monday on holiday so couldn't test it properly.

So I went in to test this morning all hopeful....and sadly I am getting an...

Ok you lot will be the only ones who will understand the fact that I cracked it with this:

RIGHT("0" + (DT_STR, 4, 1252) DATEPART("yyyy" , DATEADD("dd",-1,GETDATE())), 4) + "-" +...

I actually need to pass the date as a string in format yyyy-mm-dd, I knew I would forget to mention something!

So both ways worked, sadly my package fails because it's...

Thank you, I adapted it so that it used a field I had rather than a parameter and it worked so far.

Will test it on Monday to see the...

It is a matrix table that I am using yes :), sorry should have mentioned that.

Brandie Tarvin (7/22/2016)

---

Kazmerelda (7/22/2016)

---

GilaMonster (7/21/2016)

---

I doubt it's anything to do with the app. RStudio doesn't have query designer features, R (the language) just connects to SQL using ODBC and passes...

GilaMonster (7/21/2016)

---

I doubt it's anything to do with the app. RStudio doesn't have query designer features, R (the language) just connects to SQL using ODBC and passes over whatever query...

Not going to argue with you (definitely preaching to the choir), sadly some of these people go rogue.

Thanks for the input, I had to put my DBA head back on...

You know, I was playing around with Quarter but couldn't get it to work. Literally thank you SO much, I was partway there with what you have given me it...

Well my query even with the CASE in there is now running in 3 seconds versus 25 so thank you so much for your pointers there.

I will battle away...

GilaMonster, thanks for that. I do clean up my code before it goes live so it's all the same format.

Interesting re column names with spaces, I will do some...

Hugo Kornelis (4/14/2016)

---

Actually, int has a higher precedence than string, so the implicit conversion should be from...

I had a chuckle at my code being sloppy, I am getting there 😛 😉 (I am not offended I still have SO much to learn).

Am going to hit the...

I thought I was doing so well this time with posting the code this time rarrghhhh.

I have for now run it and sorted in excel but want to sort it...