Valid Date Formats

Owned by Will Wilson (Deactivated)
Last updated: Feb 12, 2016
2 min read

In the MobileSmith platform, you can upload data into the MobileSmith platform via CSV file.  You can also use data from a remote source (i.e. the data is not stored in the MobileSmith platform).  In both cases, you might have data that is a date, a time, or both.  The MobileSmith platform can recognize this data and allow date-and-time-related functionality, such as the ability for the app user to add an event to his phone's calendar.  In order for the platform to recognize the data, it must be in one of the accepted formats, which are listed below.

  • YYYY-MM-DD
  • YYYY-MM-DD HH:MM
  • YYYY-MM-DD HH:MM:SS
  • YYYY-MM-DD HH:MM:SS.SSS
  • YYYY-MM-DDTHH:MM
  • YYYY-MM-DDTHH:MM:SS
  • YYYY-MM-DDTHH:MM:SS.SSS
  • HH:MM
  • HH:MM:SS
  • HH:MM:SS.SSS
  • now
  • DDDDDDDDDD

 

These examples will use April 1st, 2013 at 1:15am EST as a sample reference date. NOTE: the delimiter between the year, month, and day in the date format could be represented in the date value as a space, a dash, or a slash character, but the data value may not omit the delimiter between the the parts of the date all together. For example, '2013 04 01' is a valid date format, but '20130401' is not a valid format.

Date FormatDate Example
yyyy MM dd Z2013/04/01 -0400
yyyy MM dd2013/04/01
yyyy MM d2013/04/1
MM dd yyyy04/01/2013
MMMM dd yyyyApril 01, 2013
M dd yyyy4/01/2013
M d yyyy4/1/2013
Time FormatTime Example
hh:mm:ss a01:15:00 AM
HH:mm:ss13:15:00
hh:mm a01:15 AM
HH:mm13:15
HH:mm:ss Z13:15:00 -0400
HH:mm Z13:15 -0400
DateTime FormatDateTime Example
yyyy MM dd HH:mm:ss Z2013 04 01 13:15:00 -0400
yyyy MM dd HH:mm:ss2013 04 01 13:15:00
yyyy MM dd HH:mm Z2013 04 01 13:15 -0400
yyyy MM dd HH:mm2013 04 01 13:15
yyyy MM dd'T'HH:mm:ssZZZZZ2013 04 01T13:15:00-0400
EEE dd MMM yyyy HH:mm:ss ZMon 01 Apr 2013 13:15:00 -0400
EEE d MMM yyyy HH:mm:ss ZMon 1 Apr 2013 13:15:00 -0400
yyyy MM dd hh:mm:ss a2013 04 01 01:15:00 PM
yyyy MM dd hh:mm a2013 04 01 01:15 PM
yyyy MM dd hh:mm:ss a2013 04 01 01:15:00 PM
MM dd yyyy hh:mm:ss a04 01 2013 01:15:00 PM
MM dd yyyy HH:mm:ss04 01 2013 13:15:00
M dd yyyy hh:mm:ss a4 01 2013 01:15:00 PM
M dd yyyy HH:mm:ss4 01 2013 13:15:00
MMMM dd yyyy hh:mm aApril 01 2013 01:15 PM
MMMM dd yyyy HH:mmApril 01 2013 13:15
MM dd yyyy hh:mm a04 01 2013 01:15 PM
MM dd yyyy HH:mm04 01 2013 13:15
M dd yyyy hh:mm a4 01 2013 01:15 PM
M dd yyyy HH:mm4 01 2013 13:15
M dd yy hh:mm a4 01 13 01:15 PM
M dd yy HH:mm4 01 13 13:15