--- title: "CloudNine Analyst: Date Time Stamp Formatting" description: Date Time Stamp Formatting for import --- [Skip to content](https://kb.cloudnine.com/date-time-stamp-formatting#main-content) English Show submenu for translations [Contact us](https://kb.cloudnine.com/kb-tickets/new?hsLang=en) ![CloudNine](https://kb.cloudnine.com/hs-fs/hubfs/1%20-%20CloudNine%20MARKETING/1%20-%20LOGOS/CloudNine%20Logos/CloudNine_Transparent_Low%20Res.png?width=250&height=94&name=CloudNine_Transparent_Low%20Res.png) Open main navigation Close main navigation - English Show submenu for translations - [Contact us](https://kb.cloudnine.com/kb-tickets/new) - [Go to cloudnine.com](https://cloudnine.com/) [Go to cloudnine.com](https://cloudnine.com/) Hello. How can we help you? - There are no suggestions because the search field is empty. 1. [Help Center](https://kb.cloudnine.com/?hsLang=en) 2. [CloudNine Analyst](https://kb.cloudnine.com/cloudnine-analyst?hsLang=en) 3. [Import](https://kb.cloudnine.com/cloudnine-analyst?hsLang=en#import) # CloudNine Analyst: Date Time Stamp Formatting ## Date Time Stamp Formatting for import Date time stamps are at the heart of any investigation. They are critical components to knowing when something occurred, and no investigation is complete without them!   Having the proper timestamp formats in your load file is critical to ensure the successful ingestion of your metadata.    CloudNine Analyst can recognize almost any Date Time format string value ranging from a full date string such as "Saturday, May 22nd, 2021 12:22:22 PM" to "2021-05-22 12:22:22 PM".   The 2 most common formats for supplying a date time are often the following: 1. yyyy-mm-dd hh:mm:ss 2. mm/dd/yyyy hh:mm:ss If the date separator is a forward slash ("/"), then the first digits of the date stamp will be assumed to be the month (e.g. mm/dd/yyyy). If the date separator is a dash ("-"), then the first digits will be interpreted as the year (e.g. yyyy-mm-dd). This is important when working with date stamps that provide a 2-digit value for the year.   For reference to the standard we comply with of ISO 8601, please [see article here](https://en.wikipedia.org/wiki/ISO_8601).   Time stamps are best supplied in a hh:mm:ss format. CloudNine Analyst does not work with milliseconds.  ### **Time Stamp Exceptions** For Transactions, there may not be a timestamp associated with certain types of banking records, for example when a check was deposited. Although most banking institutions now have mechanisms for capturing a timestamp, manual transactions may just record the date. To accommodate this anomaly, Transaction metadata imports have a field entitled “Has\_Timestamp”. By default, this is set to a “True” value (it can be supplied as 1/0, Yes/No or True/False). If this flag is set to "False", the timestamp on the metadata item will be ignored and a value of 12:00:00 PM will be used. This allows for proper adjustment for end-user time zones, keeping the Transaction relative to the end-user.   If you are using Microsoft's Excel to format your load file beware that Excel likes to drop the seconds off of the timestamp! Unless you modify your date time format directly in Excel this can be problematic. To prevent Excel from munging dates, you can use a "T" value between the date and time values (e.g. "yyyy-mm-ddThh:mm:ss" - in Excel you must select "custom" format an input this as the pattern)​     - [CloudNine Training Videos](https://kb.cloudnine.com/cloudnine-training-videos?hsLang=en#main-content) - [CloudNine Videos by Product](https://kb.cloudnine.com/cloudnine-training-videos?hsLang=en#cloudnine-videos-by-product) - [CloudNine Review](https://kb.cloudnine.com/cloudnine-review?hsLang=en#main-content) - [CloudNine Review Video Library](https://kb.cloudnine.com/cloudnine-review?hsLang=en#cloudnine-review-video-library) - [Section 1: Getting Started](https://kb.cloudnine.com/cloudnine-review?hsLang=en#section-1-getting-started) - [Getting Started: My Projects](https://kb.cloudnine.com/cloudnine-review?hsLang=en#getting-started-my-projects) - [Section 2: Understanding Different Views](https://kb.cloudnine.com/cloudnine-review?hsLang=en#section-2-understanding-different-views) - [Section 3: Searching](https://kb.cloudnine.com/cloudnine-review?hsLang=en#section-3-searching) - [Section 3A. Smart Filters](https://kb.cloudnine.com/cloudnine-review?hsLang=en#section-3a-smart-filters) - [3b: Search Term Lists](https://kb.cloudnine.com/cloudnine-review?hsLang=en#3b-search-term-lists) - [Section 4: Working with Documents](https://kb.cloudnine.com/cloudnine-review?hsLang=en#section-4-working-with-documents) - [Generating Images](https://kb.cloudnine.com/cloudnine-review?hsLang=en#generating-images) - [Automated Redaction](https://kb.cloudnine.com/cloudnine-review?hsLang=en#automated-redaction) - [Exporting/Producing](https://kb.cloudnine.com/cloudnine-review?hsLang=en#exporting-producing) - [Section 5: Administrative Functions](https://kb.cloudnine.com/cloudnine-review?hsLang=en#section-5-administrative-functions) - [Reporting](https://kb.cloudnine.com/cloudnine-review?hsLang=en#reporting) - [Frequently Asked Questions and Issues](https://kb.cloudnine.com/cloudnine-review?hsLang=en#frequently-asked-questions-and-issues) - [Cloud Connector](https://kb.cloudnine.com/cloudnine-review?hsLang=en#cloud-connector) - [EULA](https://kb.cloudnine.com/cloudnine-review?hsLang=en#eula) - [CloudNine Discovery Portal](https://kb.cloudnine.com/cloudnine-discovery-portal?hsLang=en#main-content) - [CloudNine Discovery Portal Video Library](https://kb.cloudnine.com/cloudnine-discovery-portal?hsLang=en#cloudnine-discovery-portal-video-library) - [Getting Started](https://kb.cloudnine.com/cloudnine-discovery-portal?hsLang=en#getting-started) - [File System Workflows](https://kb.cloudnine.com/cloudnine-discovery-portal?hsLang=en#file-system-workflows) - [Data Transfer Workflows](https://kb.cloudnine.com/cloudnine-discovery-portal?hsLang=en#data-transfer-workflows) - [LAW Bridge](https://kb.cloudnine.com/cloudnine-discovery-portal?hsLang=en#law-bridge) - [Global Monitoring Console](https://kb.cloudnine.com/cloudnine-discovery-portal?hsLang=en#global-monitoring-console) - [Advanced Features & Troubleshooting](https://kb.cloudnine.com/cloudnine-discovery-portal?hsLang=en#advanced-features-troubleshooting) - [LAW](https://kb.cloudnine.com/law?hsLang=en#main-content) - [CloudNine LAW Video Library](https://kb.cloudnine.com/law?hsLang=en#cloudnine-law-video-library) - [CloudNine LAW: Did You Know?](https://kb.cloudnine.com/law?hsLang=en#cloudnine-law-did-you-know) - [Installation and Setup](https://kb.cloudnine.com/law?hsLang=en#installation-and-setup) - [Print Queue Management](https://kb.cloudnine.com/law?hsLang=en#print-queue-management) - [Turbo Import](https://kb.cloudnine.com/law?hsLang=en#turbo-import) - [ED Loader](https://kb.cloudnine.com/law?hsLang=en#ed-loader) - [Errors](https://kb.cloudnine.com/law?hsLang=en#errors) - [Email](https://kb.cloudnine.com/law?hsLang=en#email) - [Endorse](https://kb.cloudnine.com/law?hsLang=en#endorse) - [Document Numbering](https://kb.cloudnine.com/law?hsLang=en#document-numbering) - [Annotations](https://kb.cloudnine.com/law?hsLang=en#annotations) - [Image Conversion](https://kb.cloudnine.com/law?hsLang=en#image-conversion) - [Near Dupe](https://kb.cloudnine.com/law?hsLang=en#near-dupe) - [SQL](https://kb.cloudnine.com/law?hsLang=en#sql) - [Batch Printing HTML](https://kb.cloudnine.com/law?hsLang=en#batch-printing-html) - [DataSent](https://kb.cloudnine.com/law?hsLang=en#datasent) - [Filter and Search](https://kb.cloudnine.com/law?hsLang=en#filter-and-search) - [Administration](https://kb.cloudnine.com/law?hsLang=en#administration) - [Explore](https://kb.cloudnine.com/explore?hsLang=en#main-content) - [CloudNine Explore Video Library](https://kb.cloudnine.com/explore?hsLang=en#cloudnine-explore-video-library) - [Managing Cases](https://kb.cloudnine.com/explore?hsLang=en#managing-cases) - [Importing](https://kb.cloudnine.com/explore?hsLang=en#importing) - [Searching](https://kb.cloudnine.com/explore?hsLang=en#searching) - [Exporting](https://kb.cloudnine.com/explore?hsLang=en#exporting) - [Concordance](https://kb.cloudnine.com/concordance?hsLang=en#main-content) - [Searching](https://kb.cloudnine.com/concordance?hsLang=en#searching) - [eDocs](https://kb.cloudnine.com/concordance?hsLang=en#edocs) - [Email](https://kb.cloudnine.com/concordance?hsLang=en#email) - [Other](https://kb.cloudnine.com/concordance?hsLang=en#other) - [Exporting](https://kb.cloudnine.com/concordance?hsLang=en#exporting) - [Proof of Concept](https://kb.cloudnine.com/concordance?hsLang=en#proof-of-concept) - [Concordance Desktop](https://kb.cloudnine.com/concordance-desktop?hsLang=en#main-content) - [Email Database](https://kb.cloudnine.com/concordance-desktop?hsLang=en#email-database) - [CloudNine Analyst](https://kb.cloudnine.com/cloudnine-analyst?hsLang=en#main-content) - [CloudNine Analyst Video Library](https://kb.cloudnine.com/cloudnine-analyst?hsLang=en#cloudnine-analyst-video-library) - [FAQ](https://kb.cloudnine.com/cloudnine-analyst?hsLang=en#faq) - [Known Issues and Behavior](https://kb.cloudnine.com/cloudnine-analyst?hsLang=en#known-issues-and-behavior) - [Account](https://kb.cloudnine.com/cloudnine-analyst?hsLang=en#account) - [Projects](https://kb.cloudnine.com/cloudnine-analyst?hsLang=en#projects) - [Import](https://kb.cloudnine.com/cloudnine-analyst?hsLang=en#import) - [Export](https://kb.cloudnine.com/cloudnine-analyst?hsLang=en#export) - [Machine Translation](https://kb.cloudnine.com/cloudnine-analyst?hsLang=en#machine-translation) - [Reports](https://kb.cloudnine.com/cloudnine-analyst?hsLang=en#reports) - [Investigations](https://kb.cloudnine.com/cloudnine-analyst?hsLang=en#investigations) - [ESIA Desktop](https://kb.cloudnine.com/cloudnine-analyst?hsLang=en#esia-desktop) - [ESIA Sync](https://kb.cloudnine.com/cloudnine-analyst?hsLang=en#esia-sync) - [Administration](https://kb.cloudnine.com/cloudnine-analyst?hsLang=en#administration) - [On Premise Software Q&A](https://kb.cloudnine.com/on-premise-software-qa?hsLang=en#main-content) - [On Premise Software](https://kb.cloudnine.com/on-premise-software-qa?hsLang=en#on-premise-software) - [EULA](https://kb.cloudnine.com/on-premise-software-qa?hsLang=en#eula) [![CloudNine](https://kb.cloudnine.com/hs-fs/hubfs/1%20-%20CloudNine%20MARKETING/1%20-%20LOGOS/CloudNine%20Logos/CloudNine_Transparent_Low%20Res.png?width=250&height=94&name=CloudNine_Transparent_Low%20Res.png "CloudNine")](http://www.cloudnine.com) 12848 Queensbury Lane, Suite 208 | Houston, TX  77024 | 713-999-4280 | [info@cloudnine.com](mailto:info@cloudnine.com) Copyright © 2026, CloudNine