Date and Time Formats in SDF Custom Objects

SuiteCloud Development Framework (SDF) uses a standard date and time format across all supported SDF custom objects. The date and time format is based on the UTC standard, and is ISO compliant to ensure data consistency and compatibility in SuiteCloud projects.

If the incorrect date and time format is specified, the validation log returns an error with the correct date and time format to use. For information about the custom fields that are supported in NetSuite, see Field Type Descriptions for Custom Fields.

For information about the UTC standard, see:

• https://www.timeanddate.com/time/aboututc.html

• https://en.wikipedia.org/wiki/Coordinated_Universal_Time

• https://en.wikipedia.org/wiki/ISO_8601

Important:

SDF custom objects do not support seconds. If you deploy an SDF custom object that contains a field with a Time or Date And Time value that contains seconds, the seconds are not retained in the target NetSuite account.

Date and time can be specified in the following ways:

• Date is expressed in yyyy-MM-dd format. For example, 2020-07-24 is a valid Date value.

• Time can be expressed in following ways:

  • Time With Time Zone is expressed in HH:mm:00Z format, where Z represents the UTC standard and HH is a 24 hour value. For example, 09:30:00Z is a valid Time With Time Zone value. Some fields, such as custom record custom fields, do not have time zones, so they require Time values that do not specify a time zone.

    When a Time With Time Zone value is deployed to an account, the time is converted from the UTC standard to the time zone preference of the account. For example, if you deploy a Time With Time Zone value of 09:30:00Z to an account with the time zone set to Pacific Daylight Time (PDT or UTC–7), the date remains the same but the time is set to 2:30 PM.

  • Time Without Time Zone is expressed in HH:mm:00 format, and represents a time of day that occurs regardless of the time zone. For example, 09:30:00 is a valid Time Without Time Zone value.

• Date And Time is expressed in yyyy-MM-ddTHH:mm:00Z format, where Z represents the UTC standard and HH is a 24 hour value. For example, 2020-07-24T09:30:00Z is a valid Date And Time value.

  When a Date And Time value is deployed to an account, the time is converted from the UTC standard to the time zone preference of the account. For example, if you deploy a Date And Time value of 2020-06-23T09:30:00Z to an account with the time zone set to Pacific Daylight Time (PDT or UTC–7), the date remains the same but the time is set to 2:30 PM.

Example

The following example shows date and time used in a custom record and an instance of that custom record:

            <customrecordtype scriptid="customrecord24">

  <accesstype>CUSTRECORDENTRYPERM</accesstype>

  <allowattachments>F</allowattachments>

  <allowinlinedeleting>F</allowinlinedeleting>

  <allowinlinedetaching>F</allowinlinedetaching>

  <allowinlineediting>F</allowinlineediting>

  <allowmobileaccess>F</allowmobileaccess>

  <allownumberingoverride>F</allownumberingoverride>

  <allowquickadd>F</allowquickadd>

  <allowquicksearch>F</allowquicksearch>

  <allowuiaccess>T</allowuiaccess>

  <description></description>

  <enabledle>F</enabledle>

  <enablekeywords>F</enablekeywords>

  <enablemailmerge>F</enablemailmerge>

  <enablenumbering>F</enablenumbering>

  <enableoptimisticlocking>F</enableoptimisticlocking>

  <enablesystemnotes>F</enablesystemnotes>

  <hierarchical>F</hierarchical>

  <icon></icon>

  <iconbuiltin>T</iconbuiltin>

  <iconindex></iconindex>

  <includeinsearchmenu>F</includeinsearchmenu>

  <includename>T</includename>

  <isinactive>F</isinactive>

  <isordered>F</isordered>

  <numberinginit></numberinginit>

  <numberingmindigits></numberingmindigits>

  <numberingprefix></numberingprefix>

  <numberingsuffix></numberingsuffix>

  <recordname>Customer Contact</recordname>

  <showcreationdate>F</showcreationdate>

  <showcreationdateonlist>F</showcreationdateonlist>

  <showid>F</showid>

  <showlastmodified>F</showlastmodified>

  <showlastmodifiedonlist>F</showlastmodifiedonlist>

  <shownotes>F</shownotes>

  <showowner>F</showowner>

  <showownerallowchange>F</showownerallowchange>

  <showowneronlist>F</showowneronlist>

  <customrecordcustomfields>

    <customrecordcustomfield scriptid="custrecord1">

      <accesslevel>2</accesslevel>

      <allowquickadd>F</allowquickadd>

      <applyformatting>F</applyformatting>

      <checkspelling>F</checkspelling>

      <defaultchecked>F</defaultchecked>

      <defaultselection></defaultselection>

      <defaultvalue></defaultvalue>

      <description></description>

      <displayheight></displayheight>

      <displaytype>NORMAL</displaytype>

      <displaywidth></displaywidth>

      <dynamicdefault></dynamicdefault>

      <encryptatrest>F</encryptatrest>

      <fieldtype>TIMEOFDAY</fieldtype>

      <globalsearch>F</globalsearch>

      <help></help>

      <isformula>F</isformula>

      <ismandatory>F</ismandatory>

      <isparent>F</isparent>

      <label>Time Contacted</label>

      <linktext></linktext>

      <maxlength></maxlength>

      <maxvalue></maxvalue>

      <minvalue></minvalue>

      <onparentdelete></onparentdelete>

      <parentsubtab></parentsubtab>

      <rolerestrict>F</rolerestrict>

      <searchcomparefield></searchcomparefield>

      <searchdefault></searchdefault>

      <searchlevel>2</searchlevel>

      <selectrecordtype></selectrecordtype>

      <showinlist>F</showinlist>

      <sourcefilterby></sourcefilterby>

      <sourcefrom></sourcefrom>

      <sourcelist></sourcelist>

      <storevalue>T</storevalue>

      <subtab></subtab>

    </customrecordcustomfield>

    <customrecordcustomfield scriptid="custrecord2">

      <accesslevel>2</accesslevel>

      <allowquickadd>F</allowquickadd>

      <applyformatting>F</applyformatting>

      <checkspelling>F</checkspelling>

      <defaultchecked>F</defaultchecked>

      <defaultselection></defaultselection>

      <defaultvalue></defaultvalue>

      <description></description>

      <displayheight></displayheight>

      <displaytype>NORMAL</displaytype>

      <displaywidth></displaywidth>

      <dynamicdefault></dynamicdefault>

      <encryptatrest>F</encryptatrest>

      <fieldtype>DATE</fieldtype>

      <globalsearch>F</globalsearch>

      <help></help>

      <isformula>F</isformula>

      <ismandatory>F</ismandatory>

      <isparent>F</isparent>

      <label>Date of Follow-up</label>

      <linktext></linktext>

      <maxlength></maxlength>

      <maxvalue></maxvalue>

      <minvalue></minvalue>

      <onparentdelete></onparentdelete>

      <parentsubtab></parentsubtab>

      <rolerestrict>F</rolerestrict>

      <searchcomparefield></searchcomparefield>

      <searchdefault></searchdefault>

      <searchlevel>2</searchlevel>

      <selectrecordtype></selectrecordtype>

      <showinlist>F</showinlist>

      <sourcefilterby></sourcefilterby>

      <sourcefrom></sourcefrom>

      <sourcelist></sourcelist>

      <storevalue>T</storevalue>

      <subtab></subtab>

    </customrecordcustomfield>

    <customrecordcustomfield scriptid="custrecord3">

      <accesslevel>2</accesslevel>

      <allowquickadd>F</allowquickadd>

      <applyformatting>F</applyformatting>

      <checkspelling>F</checkspelling>

      <defaultchecked>F</defaultchecked>

      <defaultselection></defaultselection>

      <defaultvalue></defaultvalue>

      <description></description>

      <displayheight></displayheight>

      <displaytype>NORMAL</displaytype>

      <displaywidth></displaywidth>

      <dynamicdefault></dynamicdefault>

      <encryptatrest>F</encryptatrest>

      <fieldtype>DATETIMETZ</fieldtype>

      <globalsearch>F</globalsearch>

      <help></help>

      <isformula>F</isformula>

      <ismandatory>F</ismandatory>

      <isparent>F</isparent>

      <label>Date and Time of Response</label>

      <linktext></linktext>

      <maxlength></maxlength>

      <maxvalue></maxvalue>

      <minvalue></minvalue>

      <onparentdelete></onparentdelete>

      <parentsubtab></parentsubtab>

      <rolerestrict>F</rolerestrict>

      <searchcomparefield></searchcomparefield>

      <searchdefault></searchdefault>

      <searchlevel>2</searchlevel>

      <selectrecordtype></selectrecordtype>

      <showinlist>F</showinlist>

      <sourcefilterby></sourcefilterby>

      <sourcefrom></sourcefrom>

      <sourcelist></sourcelist>

      <storevalue>T</storevalue>

      <subtab></subtab>

    </customrecordcustomfield>

    <customrecordcustomfield scriptid="custrecord4">

      <accesslevel>2</accesslevel>

      <allowquickadd>F</allowquickadd>

      <applyformatting>F</applyformatting>

      <checkspelling>F</checkspelling>

      <defaultchecked>F</defaultchecked>

      <defaultselection></defaultselection>

      <defaultvalue></defaultvalue>

      <description></description>

      <displayheight></displayheight>

      <displaytype>NORMAL</displaytype>

      <displaywidth></displaywidth>

      <dynamicdefault></dynamicdefault>

      <encryptatrest>F</encryptatrest>

      <fieldtype>TIMEOFDAY</fieldtype>

      <globalsearch>F</globalsearch>

      <help></help>

      <isformula>F</isformula>

      <ismandatory>F</ismandatory>

      <isparent>F</isparent>

      <label>Regularly Unavailable Time</label>

      <linktext></linktext>

      <maxlength></maxlength>

      <maxvalue></maxvalue>

      <minvalue></minvalue>

      <onparentdelete></onparentdelete>

      <parentsubtab></parentsubtab>

      <rolerestrict>F</rolerestrict>

      <searchcomparefield></searchcomparefield>

      <searchdefault></searchdefault>

      <searchlevel>2</searchlevel>

      <selectrecordtype></selectrecordtype>

      <showinlist>F</showinlist>

      <sourcefilterby></sourcefilterby>

      <sourcefrom></sourcefrom>

      <sourcelist></sourcelist>

      <storevalue>T</storevalue>

      <subtab></subtab>

    </customrecordcustomfield>

  </customrecordcustomfields>

  <instances>

    <instance scriptid="val_51121_mstrwlf_384">

      <custrecord1>22:30:00</custrecord1>

      <custrecord2>2020-08-03</custrecord2>

      <custrecord3>2020-02-02T03:30:00Z</custrecord3>

      <custrecord4>18:30:00:00Z</custrecord4>

      <isinactive>F</isinactive>

      <name>Susie Smith</name>

    </instance>

  </instances>

</customrecordtype> 

          

Related Topics

Developing SDF Custom Objects

Syntax Guidelines and Reference Formats for SDF Custom Objects

Translatable Fields on SDF Custom Objects

Downloading the XML Definition of an Object from a NetSuite Account

SDF Custom Object File Structure

Account-Specific Values Validation in SuiteCloud Projects

Lists, Records, and Fields

Reports

Forms

Import and Export

Published Dashboards and Portlets

Scripting

Plug-ins

Centers and Tabs

Users and Roles in SDF

Templates

SuiteCommerce Web Site Management

SuiteAnalytics Workbooks

General Notices