|
|
|
|
|
|
|
|
Brams On SharePoint
|
Information Worker > Blogs > Brams On SharePoint
|
| SharePoint Consulting |
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 |
|
|
|
|
|
|
|
|
|
|