How can I display the Date and Time in different formats in Xtraction?
Pic.1. Short month name and long year of the date and 12h format of the time displayed in Xtraction
The setting to change the date and time display format is located in Xtraction Settings application on Xtraction Dates tab
Pic.2. Format option where you can change Date and Time display in Xtraction
Pic.3. Date in short month name, long year and time format with 24h display
There are several options you can use, manipulating them, to display the date and time format (not all the combinations are included in the list but you can use them testing your own display format). You can, for instance, change to display date in full month name, long year and 24h display format.
'd-MMMM-yyyy H:mm tt' will give you the date and time displayed as '29-June-2017 10:18 AM'
In the above example, 'MMMM' will give you full month name, 'yyyy' - long year format, 'H' - 24h display format, 'tt' - 'AM' or 'PM' displayed
Few other options (please test it on your side so you can choose the display format that meets your requirements):
'MMM' - short month
'h' -12h display format
'yy' - short year format
Pic.4. Display format of '29-June-2017 10:18 AM'
Pic.5. Date and time displayed in full month name, long year and 24h display format
Please also make sure to do IISReset after applying the change in Xtraction Settings application and refresh the Xtraction Application page (refresh page using F5 or simply press 'Enter') so that the change will take place. Please perform IISReset after working hours not to disconnect working users.