A customer asked how we can add "custom formats" to a date field (11/6) like the picture below (right one).
In your <label> element you can add the property "type" and "format".
- type you can give it the value "date"
- format you can give it the below formats
Format options
| Specifier ---> Description ---> Output |
| d ---> Short Date ---> 08/04/2007 |
| D ---> Long Date ---> 08 April 2007 |
| t ---> Short Time ---> 21:08 |
| T ---> Long Time ---> 21:08:59 |
| f ---> Full date and time ---> 08 April 2007 21:08 |
| F ---> Full date and time (long) ---> 08 April 2007 21:08:59 |
| g ---> Default date and time ---> 08/04/2007 21:08 |
| G ---> Default date and time (long) ---> 08/04/2007 21:08:59 |
| M ---> Day / Month ---> 08 April |
| r ---> RFC1123 date ---> Sun, 08 Apr 2007 21:08:59 GMT |
| s ---> Sortable date/time ---> 2007-04-08T21:08:59 |
| Y ---> Month / Year ---> April 2007 |
| dd ---> Day ---> 08 |
| ddd ---> Short Day Name ---> Sun |
| dddd ---> Full Day Name ---> Sunday |
| hh ---> 2 digit hour ---> 09 |
| HH ---> 2 digit hour (24 hour) ---> 21 |
| mm ---> 2 digit minute ---> 08 |
| MM ---> Month ---> 04 |
| MMM ---> Short Month name ---> Apr |
| MMMM ---> Month name ---> April |
| ss ---> seconds ---> 59 |
| tt ---> AM/PM ---> PM |
| yy ---> 2 digit year ---> 07 |
| yyyy ---> 4 digit year ---> 2007 |
| : ---> seperator, e.g. {0:hh:mm:ss} ---> 09:08:59 |
| / ---> seperator, e.g. {0:dd/MM/yyyy} ---> 08/04/2007 |
To make things easy I already scripted the above events view in combination with an Excel sheet.
I've uploaded both the Excel file used + the view XML in this post. You can copy / paste the XML into your pro block and possibly change the fields according to your Excel sheet if needed.