I ran accross a field in a flat file yesterday that was in the format of "CCYYDDD". Now I can only assume that "CC" means century, but that's not the point. The actual value was "2008294". I needed to write an expression that converted the year and day of year format to a standard date. Here's the expression to do this (thank you to Ed Buhain for brainstorming):
DATEADD("d", ((DT_I4)SUBSTRING(Date, 5, 3) - 1), (DT_DATE)("1/1/" + SUBSTRING(Date, 1, 4)))
Where "Date" is the value you need to convert.
Pretty straight forward. Just subtact 1 from the day of year value and add to January 1st using DateAdd. The end result in this case is "10/20/2008"
If in the past you have had the problem where the contacts in your personal outlook contact folder do not appear in the list of address folders when you click the "To..." button when sending an email, here is a solution. (Thanks to Burton White of Excella Consulting)
Tools -> Email Accounts
Select "Add a new directory or address book"
Select "Additional address books"
Select "Outlook Address book"
When you do a search for an address by clicking "To..." in an email, it defaults to show your addresses in the form "firstname lastname". If you want to change that:
Tools -> Email Accounts
Select "View or change existing directories or address books"
Select "Change" button
Select "File as (Smith, John)"
Also, when you do a search for an address by clicking "To..." in an email, it shows the addresses in the Exchange server first. If you want to change that to your Outlook Address book:
Tools -> Address book...
Tools -> Options
Select what you want in the drop down list "Show this address list first..."
After many long hours working on upgrading our clients intranet from SPS 2003 to MOSS, we completed the rollout over a very long weekend. Ed Buhain, the client and I spent a fair bit of time babysitting the process, tackling last minute gotchas as they came up.
One of the final issues we had was after all of the time testing, debugging, prepping, etc we had not run through the upgrade process with the infrastructure update applied. I was fully prepared to do my workarounds in order to get all the content moved. However, during upgrade process we learned that many of the issues that we had hit previously were now no longer issues. I must assume that these bugs were addressed in either SP1 or the infrastructure update. For example:
- We fully expected that the WSUS_ database would not be sized correctly, therefore large content DB's would cause it to autogrow when copying the document related tables. The temp database did size correctly or adequately during the upgrade.
- Timeouts were an issue due to the tempdb and wsus_ databases thrashing SQL Server. This also did not seem to be an issue during the upgrade. SQL Server stayed relatively quiet during the process.
We did run into an issue with creating advanced search pages and a search center. Still working those bugs out. All in all I think it was a success. We also managed to squeeze in a new master page with a fresh new look and branding which ultimately was the "sizzle" the new site needed.
Good times...good times.