My Dah! So simple... Thanks!

Thanks Jeff! Briefly looked it over and looks like it has many nuggets of golden information to extract!

Thanks for your reply CEWII

Thanks SSCrazy. Was pretty sure of that but down to a few volts in the powerhouse at the moment 🙂

Found this article/post that looks pretty close to my required needs.

http://www.sqlservercentral.com/articles/powershell/73460/

Anyone with others great links or comment on person experience please reply. Thanks!

Great stuff. Thanks very much!

I happened alone the below function that gets the job done. Your article referral looks to be a great resource too. Thanks!

Function fnFormatDate(dtDate, strFormat)

Dim yyyy, mm, dd

mm = Month(dtDate)

yyyy=Year(dtDate)

dd=Day(dtDate)

If (Len(dd)<2)...

Thank you so much! 🙂

Really no reply? I am getting the same error message. If you got this figured out how does it work?

Thanks

Thank you for all the great responses. The thread took on a life of its own which is cool 🙂

SQL Prompt is pretty nifty 🙂

Your right no business logic documented. I have been tasked with doing that.

Thank bunches. It is code used within our application I support. It is pretty ugly no doubt but really cool how you broke it down. It boggled my mind. Thanks!

That is the ticket Elliot! Thanks so much!

I appreciate all you responses. Thanks