Page History

This class provides methods for performing operations on SimpleDateTime objects, such as instantiating objectsThe class is used to conduct operations on SimpleDateTime objects, for example, instantiating objects.

You can also use this class to perform calculate, change formats of the date-time operations, such as calculations, formatting or converting between date-time or convert between the formats.

SimpleDateTime(

dateTime)

Adds a specified number of days to the current SimpleDateTime object. The negative value of the parameter will subtract the days.

Use this constructor to instantiate a new SimpleDateTime object with the current or transferred date/time. Specify the date and time value in the UTC timezone.

Parameter(s):

Example:

var simple_date_timeconst nowDateTime = new SimpleDateTime("2019-01-01 08:00:00");
simple_date_time.addDaysLocalTime(-1)
ss.info(simple_date_time.getValue()); // 2018-12-31

addDaysUTC(days)

Adds a specified number of days to the current SimpleDateTime object. The negative value of the parameter will subtract the days.

The method determines UTC date and time equivalent to the value saved by the GlideDateTime object, then adds or subtracts the days using UTC date and time values.

Parameter(s):

Return:

//
const registrationDateTime = new SimpleDateTime(record.registration_datetime);
//
const yearStartDateTime = new SimpleDateTime('2019-01-01 00:00:00');

You can also use the values in relative format for the SimpleDateTime constructor. All formats are available in the Relative Formats article.

const yesterdayDatetime

Example:

var simple_date_time = new SimpleDateTime("2019-01-01 08:00:00"'yesterday');
simple_date_time.addDaysUTC(-1)ss.info(yesterdayDatetime.getValue());
// Info: 2022-02-28 00:00:00  

const tomorrowDatetime = new SimpleDateTime('tomorrow');
ss.info(simple_date_timetomorrowDatetime.getValue()); 
// Info: 20182022-1203-3102 0800:00:00

addMonthsLocalTime(months)

Adds a specified number of months to the current SimpleDateTime object. The negative value of the parameter will subtract the months.

The method determines local date and time equivalent to the value saved by the GlideDateTime object, then adds or subtracts the months using local date and time values.

Parameter(s):

Return:

Example:

var simple_date_time

const yesterdayWorkdayDayStart = new SimpleDateTime('yesterday 06:30');
ss.info(yesterdayWorkdayDayStart.getValue());
// Info: 2022-02-28 06:30:00

const fistDayOfNextMonthStart = new SimpleDateTime("2019-01-01 08:'first day of next month 00:00"');
simple_date_time.addMonthsLocalTime(1)
ss.info(simple_date_timefistDayOfNextMonthStart.getValue()); 
// Info: 20192022-0204-01

addMonthsUTC(months)

Adds a specified number of months to the current SimpleDateTime object. The negative value of the parameter will subtract the months.

The method determines UTC date and time equivalent to the value saved by the GlideDateTime object, then adds or subtracts the months using UTC date and time values.

Parameter(s):

 00:00:00

const rangeStartDatetime = new SimpleDateTime(`first day of ${monthName}`);
ss.info(rangeStartDatetime .getValue());
// Info: 2022-02-01 00:00:00

const YEAR = 2022;
const MONTH = 2;
const monthDatetime = new SimpleDateTime(`${YEAR}-${String(MONTH).padStart(2, '0')}-02 00:00:00`);
const monthName = monthDatetime.getMonthUTC();
ss.info(monthName);
// Info: February

addDays(days)

This method is used to change the number of days in the current SimpleDateTime object according to the local date and time. The positive value of the parameter adds days to the object, the negative value diminishes the number of days.

Parameter(s):

Return:

Example:

const registrationDateTime = new SimpleDateTime('2019-01-01 08:12:10');
registrationDateTime.addDays(3);
ss.info(registrationDateTime.getValue());
//Info: 2019-01-04 08:12:10

addMonths(months)

This method is used to change the number of months in the current SimpleDateTime object according to the local date and time. The positive value of the parameter adds months to the object, the negative value diminishes the number of months.

Parameter(s):

Return:

Example:

const registrationDateTime = new SimpleDateTime('2019-01-01 08:12:10');
registrationDateTime.addMonths(-1);
ss.info(registrationDateTime.getValue());
//Info: 2018-12-01 08:12:10

addSeconds(seconds)

This method is used to change the number of seconds in the current SimpleDateTime object according to the local date and time. The positive value of the parameter adds seconds to the object, the negative value diminishes the number of seconds.

Parameter(s):

Return:

Example:

const registrationDateTime = new SimpleDateTime('2019-01-01 08:12:10');
registrationDateTime.addSeconds(3600);
ss.info(registrationDateTime.getValue());
//Info: 2019-01-01 09:12:10

addWeeks(weeks)

This method is used to change the number of weeks in the current SimpleDateTime object according to the local date and time. The positive value of the parameter adds weeks to the object, the negative value diminishes the number of weeks.

Parameter(s):

Return:

Example:

const registrationDateTime = new SimpleDateTime('2019-01-01 08:12:10');
registrationDateTime.addWeeks(1);
ss.info(registrationDateTime.getValue());
//Info: 2019-01-08 08:12:10

addYears(years)

This method is used to change the number of years in the current SimpleDateTime object according to the local date and time. The positive value of the parameter adds years to the object, the negative value diminishes the number of years.

Parameter(s):

Return:

Example:

const contractStartDateTime = new SimpleDateTime('2019-01-01 00:00:00');
contractStartDateTime.addYears(1);
ss.info(contractStartDateTime.getValue());
//Info: 2020-01-01 00:00:00

after(dateTime)

This method allows to compare the date specified by the ‘dateTime‘ parameter with the current date. 

The method returns TRUE, if the current date is after the specified; otherwise returns FALSE.

Parameter(s):

Return:

Example:

const startDateTime = new SimpleDateTime('2018-01-01 07:58:35');
const endDateTime = new SimpleDateTime('2019-01-01 08:00:00');
const isStartAfterThanEnd = startDateTime.after(endDateTime);
ss.info(isStartAfterThanEnd);
//Info: false

before(dateTime)

This method allows to compare the date specified by the ‘dateTime‘ parameter with the current date.

The method returns TRUE, if the current date is before the specified; otherwise returns false.

Parameter(s):

Return:

Example:

const startDateTime = new SimpleDateTime('2018-01-01 07:58:35');
const endDateTime = new SimpleDateTime('2019-01-01 08:00:00');
const isStartBeforeEnd = startDateTime.before(endDateTime);
ss.info(isStartBeforeEnd);
//Info: true

compareTo(dateTime)

This method compares two date and time objects to determine whether they are equal and, if not, the method defines which goes after or before the other.

Parameter(s):

Return:

Example:

const begin = new SimpleDateTime('2019-04-01 08:15:00');
const end = new SimpleDateTime('2019-05-01 01:00:00');

ss.info(begin.compareTo(end));   // -1
ss.info(end.compareTo(begin));   // 1
ss.info(begin.compareTo(begin)); // 0

equals(dateTime)

This method compares a datetime with an existing value to determine whether they are equal or not.

Parameter(s):

Return:

Example:

const firstDateTime = new SimpleDateTime('2018-01-01 08:00:00');
const secondDateTime = new SimpleDateTime('2018-01-01 08:15:00');
const thirdDateTime = new SimpleDateTime('2018-01-01 08:00:00');

ss.info(firstDateTime.equals(secondDateTime));
ss.info(thirdDateTime.equals(firstDateTime));
//Info: false
//Info: true

getDate()

This method returns the date saved by the SimpleDateTime object in the system time zone.

Return:

Example:

const startDateTime = new SimpleDateTime('2019-01-01 08:00:00');
ss.info(startDateTime.getDate());
//Info: 2019-01-01

getDayOfMonthLocalTime()

This method returns the day of the month saved by the SimpleDateTime object in the current user's time zone.

Return:

Example:

const holidayDateTime = new SimpleDateTime('2019-01-07 08:00:00');
ss.info(holidayDateTime.getDayOfMonthLocalTime());
//Info: 7

getDayOfMonthUTC()

This method returns the day of the month saved by the SimpleDateTime object in the UTC time zone.

Return:

Example:

const holidayDateTime = new SimpleDateTime('2019-01-07 08:00:00');
ss.info(holidayDateTime.getDayOfMonthUTC());
//Info: 7

getDayOfWeekLocalTime()

This method returns the day of the week saved by the SimpleDateTime object in the current user's time zone.

Return:

Example:

const holidayDateTime = new SimpleDateTime('2019-01-07 08:00:00');
ss.info(holidayDateTime.getDayOfWeekLocalTime()); // Mon

getDayOfWeekUTC()

This method returns the day of the week saved by the SimpleDateTime object in the system time zone.

Return:

Example:

const holidayDateTime = new SimpleDateTime('2019-01-07 08:00:00');
ss.info(holidayDateTime.getDayOfWeekUTC());
//Info: Mon

getDaysInMonthLocalTime()

This method returns the number of days in the month saved by the SimpleDateTime object in the current user's time zone.

Return:

Example:

const startDateTime = new SimpleDateTime('2019-01-01 08:00:00');
ss.info(startDateTime.getDaysInMonthLocalTime());
//Info: 31

getDaysInMonthUTC()

This method returns the number of days in the month saved by the SimpleDateTime object in the system time zone.

Return:

Example:

const startDateTime = new SimpleDateTime('2019-01-01 08:00:00');
ss.info(startDateTime.getDaysInMonthUTC());
//Info: 31

getDisplayValue()

This method returns the date and time value in the current user's display format and timezone.

Return:

Example:

const startDateTime = new SimpleDateTime('2019-01-01 08:00:00');
ss.info(startDateTime.getDisplayValue()); // current user's timezone is Europe/Moscow
//Info: 2019-01-01 11:00:00 

getErrorMsg()

This method returns the error message if the SimpleDateTime object was incorrect.

Return:

Example:

const startDateTime = new SimpleDateTime('2019-zz-01 08:00:00');
ss.error(startDateTime.getErrorMsg());
//Error: DateTimeZone::getOffset() expects parameter 1 to be DateTimeInterface, null given

getLocalDate()

This method returns the date saved by the SimpleDateTime object in the current user's time zone.

Return:

Example:

const startDateTime = new SimpleDateTime('2019-01-01 08:00:00');
ss.info(startDateTime.getLocalDate());
//Info: 2019-01-01

getLocalTime()

This method returns the time saved in a SimpleDateTime object in the current user's time zone .

Return:

Example:

const startDateTime = new SimpleDateTime('2019-01-01 08:00:00');
const time = startDateTime.getLocalTime();
ss.info( "My local time is " + time.getByFormat('h:i:s'));
//Info: My local time is 02:00:00

getMonthLocalTime()

This method returns the month saved by SimpleDateTime object in the current user's time zone.

Return:

Example:

const startDateTime = new SimpleDateTime('2019-12-31 23:45:00');
ss.info(startDateTime.getMonthLocalTime());
//Info: January

getMonthUTC()

This method returns the month saved by SimpleDateTime object in the system time zone.

Return:

Example:

const startDateTime = new SimpleDateTime('2019-12-31 23:45:00');
ss.info(startDateTime.getMonthUTC());
//Info: December

getNumericValue()

This method returns the Unix timestamp, which stores the amount of seconds since January 1, 1970, 00:00:00.

Return:

Example:

const startDateTime = new SimpleDateTime('2019-01-01 08:00:00');
ss.info(startDateTime.getNumericValue());
//Info: 1546329600

getTime()

This method returns a SimpleDateTime object that shows the piece of time of the SimpleDateTime object.

Return:

Example:

const startDateTimevar simple_date_time = new SimpleDateTime("'2019-01-01 08:00:00"');
simple_date_time.addMonthsUTC(-1)const time = startDateTime.getTime();
ss.info(simple_date_time.getValue(getByFormat('h:i:s')); 
// 2018-12-01 08:00Info: 11:01:00

getValue(

)

Add a specified number of seconds to the current SimpleDateTime object.

Parameter(s):

This method returns the date and time value in the internal format.

Return:

Example:

const startDateTimevar simple_date_time = new SimpleDateTime("'2019-01-01 08:00:00");
simple_date_time.addSeconds(3600');
ss.info(simple_date_timestartDateTime.getValue()); // 2019-01-01 09:00:00

addWeeksLocalTime(weeks)

Adds a specified number of weeks to the current SimpleDateTime object. The negative value of the parameter will subtract the weeks.

The method determines local date and time equivalent to the value saved by the GlideDateTime object, then adds or subtracts the weeks using local date and time values.

Parameter(s):

08:00:00

getWeekOfYearLocalTime()

This method returns the week's number saved by the SimpleDateTime object in the current user's time zone.

Return:

Example:

var simple_date_timeconst startDateTime = new SimpleDateTime("'2019-0112-0131 0823:0045:00"');
simple_date_time.addWeeksLocalTime(2)
ss.info(simple_date_time.getValue(startDateTime.getWeekOfYearLocalTime()); 
// 2019-01-15

addWeeksUTC(weeks)

Adds a specified number of weeks to the current SimpleDateTime object. The negative value of the parameter will subtract the weeks.

The method determines UTC date and time equivalent to the value saved by the GlideDateTime object, then adds or subtracts the weeks using UTC date and time values.

Parameter(s):

Info: 1

getWeekOfYearUTC()

This method returns the number of the week saved by the SimpleDateTime object in the system time zone.

Return:

Example:

var simple_date_timeconst startDateTime = new SimpleDateTime("'2019-0112-0131 0823:0045:00"');
simple_date_time.addWeeksUTC(-1)
ss.info(simple_date_time.getValuestartDateTime.getWeekOfYearUTC()); 
// 2018-12-25 08:00:00

addYearsLocalTime(years)

Adds a specified number of years to the current SimpleDateTime object. The negative value of the parameter will subtract the years.

The method determines local date and time equivalent to the value saved by the GlideDateTime object, then adds or subtracts the years using local date and time values.

Parameter(s):

Info: 1

getYearLocalTime()

This method returns the year saved by the SimpleDateTime object in the current user's time zone.

Return:

Example:

var simple_date_timeconst holidayDateTime = new SimpleDateTime("'2019-0112-0131 0823:0045:00"');
simple_date_time.addYearsLocalTime(1)
ss.info(simple_date_time.getValueholidayDateTime.getYearLocalTime()); 
//Info: 2020-01-01

getYearUTC(

)

Adds a specified number of years to the current SimpleDateTime object. The negative value of the parameter will subtract the years.

The method determines UTC date and time equivalent to the value This method returns the year saved by the GlideDateTime object, then adds or subtracts the years using UTC date and time values.

Parameter(s):

SimpleDateTime object in the system time zone.

Return:

Example:

var simple_date_timeconst holidayDateTime = new SimpleDateTime("'2019-0112-0131 0823:0045:00");
simple_date_time.addYearsLocalTime(1)');
ss.info(simple_date_time.getValueholidayDateTime.getYearUTC()); 
// 2020-01-01

after(dateTime)

This method allows to compare the date specified by the ‘dateTime‘ parameter with the current date.

The method returns TRUE, if the current date is after the specified; otherwise returns false.

Parameter(s):

Info: 2019

isValid()

This method allows to determine if a specified value is a valid date and time.

Return:

Example:

var first_simple_date_timeconst startDateTime = new SimpleDateTime("'2019-01-01 08:00:00"');
var second_simple_date_time = new SimpleDateTime("2018-01-01 08:00:00");
let result = first_simple_date_time.after(second_simple_date_timestartDateTime.setValue('2011-aa-01 00:00:00');
ss.info(startDateTime.isValid(result)) // true

before(dateTime)

This method allows to compare the date specified by the ‘dateTime‘ parameter with the current date.

The method returns TRUE, if the current date is before the specified; otherwise returns false.

Parameter(s):

;
//Info: false

setValue(dateTime)

This method is intended to define the date and time value within the SimpleDateTime object.

Parameter(s):

Return:

Example:

var first_simple_date_timeconst startDateTime = new SimpleDateTime("'2019-01-01 08:00:00"');
var second_simple_date_time = new SimpleDateTime("2018startDateTime.setValue('2020-01-01 12:00:00');
ss.info(startDateTime.getValue());
//Info: 2020-01-01 0812:00:00");
let result = first_simple_date_time.before(second_simple_date_time);
ss.info(result) // false

compareTo(dateTime)

subtract(first, second)

This method returns the amount of time between two SimpleDateTime values. Also, it can subtract the amount of time from the current SimpleDateTime object.

Parameter(s):

Return:

Example:

var first_simple_date_timeconst startDatetime = new SimpleDateTime("2019-01-01 08:00:00");
var second_simple_date_time = new SimpleDateTime("2018-01-01 08'2019-11-08 20:00:00"');
var third_simple_date_timeconst endDatetime = new SimpleDateTime("2018'2019-0111-0108 0820:0006:00"28');

ss.info( first_simple_date_time.compareTo(second_simple_date_time) ); // 1const diffDuration = new SimpleDateTime().subtract(startDatetime, endDatetime); 
ss.info(diffDuration.getDurationSeconds( second_simple_date_time.compareTo(first_simple_date_time) ); // -1
ss.info( third_simple_date_time.compareTo(second_simple_date_time ) ); // 0

equals(dateTime)

Compares a datetime with an existing value if they are equal.

Parameter(s):

Return:

));
// Info: 388

Same example without using of the subtract:

const startDatetime = new SimpleDateTime('2019-11-08 20:00:00');
const endDatetime = new SimpleDateTime('2019-11-08 20:06:28');
const diffSeconds = endDatetime.getNumericValue() - startDatetime.getNumericValue(); 
ss.info(diffSeconds);
// Info: 388

var first_simple_date_timeconst datetime = new SimpleDateTime("2019'2020-0108-0128 0809:00:00"');
datetime.subtract(3600);
ss.info(datetime.getValue());
var second_simple_date_time = new SimpleDateTime("2018-01-01 08:00:00");
var third_simple_date_time//Info: 2020-08-28 08:00:00

Same example without using of the subtract:

const datetime = new SimpleDateTime("2018'2020-0108-0128 0809:00:00"');

ss.info( first_simple_date_time.equals(second_simple_date_time) ); // 0
datetime.addSeconds(-3600);
ss.info( third_simple_date_time.equals(second_simple_date_time ) ); // 1datetime.getValue());
//Info: 2020-08-28 08:00:00