Date record modified type

Overview #

This field type stores the timestamp indicating the most recent modification of the record. Upon creating the record, this value is initialized.

Manual modification of this field type’s value is not permissible. Instead, it is automatically updated whenever the record undergoes modification.

The default timestamp format is yyyy-MM-dd HH:mm, although it is adjustable to an alternative format.

Available features #

Display options #

Representation #

This setting determines the format for displaying both the date and time. The default format is yyyy-MM-dd HH:mm, but it can be customized to an alternative format.

While several common predefined formats are available, you also have the option to choose ‘Custom’ and define your own format following these rules:

• Era Designator: G (AD)
• Year: yy (16), yyyy (2016)
• Month: MMMM (July), MMM (Jul), MM (07)
• Week in Year: w (27)
• Day in Year: D (189)
• Day in Month: d (9), dd (09)
• Day Name in Week: EEE (Tue), EEEE (Tuesday)
• AM/PM Marker: a (PM)
• Hour in 24-hour: H (0), HH (00)
• Hour in AM/PM: h (1), hh (01)
• Minute in Hour: m (5), mm (05)
• Second in Minute: s (9), ss(09)
• Millisecond: SSS (123)
• Time Zone: z (-0700), zzzz (-07:00)

It’s also possible to define a format for the date-time picker.

REST API #

Read format #

The format represents the number of milliseconds since the Unix Epoch:

"lastUpdate": 1484578380000

Write format #

Fields of this type cannot be manually edited or written to.

JavaScript API #

Read format #

When utilizing the val() method within the wrapper, it will yield a Date object.

// this will print something like "date: Mon Jan 16 2017 14:53:00 GMT-0000 (UTC)"
log('date: '+record.field('lastUpdate').val());

Write format #

Fields of this type cannot be manually edited or written to.

Wrapper Method:
toMillis() #

This method returns the date-time in milliseconds since the Unix Epoch.

Returns #

number - The time in milliseconds since the Unix Epoch

Samples #

// prints the time in milliseconds since the Unix Epoch

var company = sys.data.findOne('companies', {name: 'Blogpad'});
log('last update millis: '+company.field('lastUpdate').toMillis());

Wrapper method:
format(pattern, timeZoneId) #

This function is used to format the date-time into a string. If a format pattern and a time zone ID are provided, they will be applied. Alternatively, if no pattern or time zone ID is given, the default display options of the field will be utilized.

Parameters #

Returns #

string - The formatted date.

Exceptions #

badRequest

If pattern or timeZoneId is invalid

Samples #

// formats date using 'MM-dd-yyyy HH:mm' pattern
var company = sys.data.findOne('companies', {name: 'Blogpad'});
log('last update millis: '+company.field('lastUpdate').format('MM-dd-yyyy HH:mm'));

// formats date-time using default display options 
var company = sys.data.findOne('companies', {name: 'Blogpad'});
log('last update millis: '+company.field('lastUpdate').format());

Export/Import #

Export format #

The export format is yyyy-MM-dd'T'HH:mm:ss.SSS'Z', with the value being converted to UTC time. This format remains consistent regardless of the display options set for that field.

"recordModifiedField"
"2017-05-14T13:20:05.145Z"

The timezone for the export format will always be UTC.

Import format #

Importing record created fields is not supported.

Queries #

For more information, please refer to the Query Language Documentation.

Available operators #

Query formats #

When working with queries, it’s essential to provide the time in milliseconds since the Unix Epoch.

// finds companies where last meeting is after '1458443760000' which is Sun Mar 20 2016 03:16:00 GMT-0000 (UTC) 
var records_sample = sys.data.find('companies', {'lastMeeting':'greater(1458443760000)'});
log('total: '+records_sample.count());
while (records_sample.hasNext()) {
    log(records_sample.next().label());
}

// finds companies where last meeting is after '1458443760000' which is Sun Mar 20 2016 03:16:00 GMT-0000 (UTC) 
var query_sample = sys.data.createQuery('companies')
    .field('lastMeeting').greater(1458443760000)
var records_sample = sys.data.find(query_sample);
log('total: '+records_sample.count());
while (records_sample.hasNext()) {
    log(records_sample.next().label());
}

// finds companies where last meeting is after '1458443760000' which is Sun Mar 20 2016 03:16:00 GMT-0000 (UTC) 
GET /data/contacts?lastMeeting=greater(1458443760000)

When utilizing the query builder, you have the option to use either a Date object or a string in the format ‘yyyy-MM-dd HH:mm’.

query.field('lastMeeting').less(new Date());
query.field('lastMeeting').less('2016-03-20 03:16');

Aggregate queries #

Please refer to the Aggregate Queries Documentation for more detailed information.

Available operators #

UI queries #

Please refer to the UI Queries Documentation for more detailed information.

Matching of values #

Available operators #