|
|
|
|
|
|
|
|
Brams On SharePoint
|
Information Worker > Blogs > Brams On SharePoint > Categories
|
10/17/2009
One of the biggest problems with SharePoint document libraries is with the inability to navigate through documents in a large library. A dynamic Tree like structure, just like the file structure you have on the file share, an ability to collapse/expand tree view is needed. Click here for more details http://sharepointbramley.blogspot.com/ 12/9/2008To change a date format say to yyyy-mm-dd, go to "Site Action" then "Site Settings" under Site Administration, click Regional settings.
But the interesting thing is when you want to have the following format: dd-mmmm-yyyy, e.g 09-December-2008. What you need to do is the following:
Create a Date column(Call Date1), leave it on the default view Then create another column for your text version date Call it what ever you want "Date 2" or something Select Calculated (calculation based on other columns) type Down in the Formula window insert this formula: TEXT([the name of your number date column goes here between the square brackets],"mmmm-dd-yyyy"), Click "Ok", essentially you have the following in brackets =TEXT(Date1,"dd-mmmm-yyyy")
| Edit in Browser | /_layouts/images/icxddoc.gif | /blogs/BramsOnSharePoint/_layouts/formserver.aspx?XsnLocation={ItemUrl}&OpenIn=Browser | 0x0 | 0x1 | FileType | xsn | 255 | | Edit in Browser | /_layouts/images/icxddoc.gif | /blogs/BramsOnSharePoint/_layouts/formserver.aspx?XmlLocation={ItemUrl}&OpenIn=Browser | 0x0 | 0x1 | ProgId | InfoPath.Document | 255 | | Edit in Browser | /_layouts/images/icxddoc.gif | /blogs/BramsOnSharePoint/_layouts/formserver.aspx?XmlLocation={ItemUrl}&OpenIn=Browser | 0x0 | 0x1 | ProgId | InfoPath.Document.2 | 255 | | Edit in Browser | /_layouts/images/icxddoc.gif | /blogs/BramsOnSharePoint/_layouts/formserver.aspx?XmlLocation={ItemUrl}&OpenIn=Browser | 0x0 | 0x1 | ProgId | InfoPath.Document.3 | 255 | | Edit in Browser | /_layouts/images/icxddoc.gif | /blogs/BramsOnSharePoint/_layouts/formserver.aspx?XmlLocation={ItemUrl}&OpenIn=Browser | 0x0 | 0x1 | ProgId | InfoPath.Document.4 | 255 | | View in Web Browser | /_layouts/images/ichtmxls.gif | /blogs/BramsOnSharePoint/_layouts/xlviewer.aspx?listguid={ListId}&itemid={ItemId}&DefaultItemOpen=1 | 0x0 | 0x1 | FileType | xlsx | 255 | | View in Web Browser | /_layouts/images/ichtmxls.gif | /blogs/BramsOnSharePoint/_layouts/xlviewer.aspx?listguid={ListId}&itemid={ItemId}&DefaultItemOpen=1 | 0x0 | 0x1 | FileType | xlsb | 255 | | Snapshot in Excel | /_layouts/images/ewr134.gif | /blogs/BramsOnSharePoint/_layouts/xlviewer.aspx?listguid={ListId}&itemid={ItemId}&Snapshot=1 | 0x0 | 0x1 | FileType | xlsx | 256 | | Snapshot in Excel | /_layouts/images/ewr134.gif | /blogs/BramsOnSharePoint/_layouts/xlviewer.aspx?listguid={ListId}&itemid={ItemId}&Snapshot=1 | 0x0 | 0x1 | FileType | xlsb | 256 |
|
|
|
|
|
|
|
|
|
|