Converting date format ready for metadata import

The UK input date/time format for Asset Bank data migrations is as follows:

dd/mm/yyyy hh:mm:ss

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:

dd/mm/yyyy hh:mm:ss

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)


Was this article helpful?

Yes No

Thanks for your feedback!

Stew, Professional Services

“With so many settings available, and such a flexible system, do not hesitate to get in touch with one of our knowledgeable consultants to help you configure your Asset Bank.” Stewart, Professional Servicest