Question
Pop quiz: I have a Dutch installation of SharePoint (WSS 3.0 or MOSS 2007) that already contains a lot of data. I want to restore the main site collection on a different server with English installation of SharePoint. Can it be done ?
Considerations
Take into account that a localized version of SharePoint requires specific resource files on disc based on LCID (en-US = 1033, etc).
Answer
Yes, you can ! But you will need the correct Language Pack for it to work. Otherwise it will just throw a "500 INTERNAL SERVER ERROR" at you.
I clicked together an easy custom announcements list with Begin and End Date and wanted for each new item the following default values:
- Begin Date = TODAY
- End Date = TODAY + 1 hour
Setting the Begin Date is easy but I scratched my head a few times for the End Date. I found the following information about Formulas on Office Online so I went on experimenting.
Since you can only add DAYS, MONTHS or YEARS to a date I figured I'd add 1/24th of a DAY which is exactly 1 HOUR ;)
Here's what I thought to be the final solution: =TODAY+0.04167
Begin Date End Date
Unfortunately TODAY uses 12:00 AM as time offset, so you can only set it to "today at 1 AM" but not to "today in exactly 1 hour".
NOTE: When using this technique in a Calculated Field (eg =[BeginDate]+0.04167) this does work.
I'm not sure this can be achieved without using javascript or Custom Field Types.