Welcome to stevienova.com. Since 2004, I have enjoyed blogging about programming, business intelligence, SharePoint, Microsoft, Google, Apple and everything to do with technology. Thoughts on life, the world or my new favorite brew, may also be shared. I currently work at Trek Bicycle Corporation, managing both the BI team and .NET software dev groups. The opinions on this blog are solely my own.
I live in Sun Prairie, WI with my girlfriend and our 2 year old daughter. Besides my love for family and technology, I am passionate about music. I play the piano, guitar and I also sing. Everyday I learn something new, and I hope to share it with you.Dates are fun. See, by default most dates come out like 5/6/2008. But computers, and programs like them formatted as 05/06/2008. That way, all the dates, no matter what month or day, are all the same length, cool huh?
Well, in Reporting Services, if you have a date field coming back in a dataset, and you want to format it as a 10 digit string, there are about 50 different ways to do it. You can use old VBA Left and Mid etc, or you can use String.Format like..
=String.Format(“{0:MM}/{0:dd}/{0:yyyy}”,CDate(Fields!CalendarDate.Value))