Support » Knowledge Base » Converting date format ready for metadata import
The UK input date/time format for Asset Bank data migrations is as follows:
To generate this format in Excel you simply have to right-click the date column and chose to 'Format cells'. In the screen that appears select 'custom' and then enter the folloiwng string:
This will convert the dates to the correct format. See the screen-shot below.
(For US dates, just use mm/dd/yyyy hh:mm:ss)
“Browse our extensive knowledgebase for quick and easy solutions.” Warren, Customer Support
Call us now on: +44 (0) 1273 923150
Or, send us a message.