I still don't understand how this works logically though. The original method did it's job in returning a single cell value to a SSIS variable. However it just didn't work...

I'll give this a go later, thank you so much!

Were you getting the same error as me with the other method? I just can't understand why it works for text...

File attached.

It shows up as 19/01/2016

Thank you for all the input!

Orlando, I'll give your method a go. However I don't understand one thing, there doesn't seem to be a problem with my syntax because it...

I don't understand what you mean? What table?

I tried to google VBA solutions, but because I am a total novice when it comes to VBA, I couldn't make any headway at all.

Can anyone give me a starter...

Apologies for the late reply, Christmas holidays!

Jacob, that solution works absolutely perfectly! It performs with no extra overhead too. Thank you so so much. Happy new year!

Still doesn't seem to be working..

Filemonth = 10

StartMonth = 12

Frequency = 6

I'm expecting NextPaymentMonth to be 12, but your code result is showing 6...

Thanks for that, I feel like I'm close with it, however I'm facing a few issues.

I have the following;

Filemonth = 10

StartMonth = 10

Frequency = 1

I'm expecting the NextPaymentMonth to be...

I can't get that piece of code to work. What is the % sign in the join?

Ok thanks. I'll give this route a go!

It's right aligned (although it doesn't actually show the right aligned button as being selected) and bottom aligned..

:unsure:

Anyone? 🙁