Date And Time Functions

How to use Data and Time Functions in KiSSFLOW

Mayakrishnan Ramar avatar
Written by Mayakrishnan Ramar
Updated over a week ago
  • Today() – This function returns today’s date.

  • Now() – This function returns the current date and time.

  • Weekday(InputDate) – This function returns an integer representing the day of the week for an input date.

DATE

The DATE function returns the sequential serial number that represents a particular date.

The syntax is:

DATE(year,month,day)

  • Year can include one to four digits.

  • Month is a positive or negative integer representing the month of the year from 1 to 12 (January to December).

  • Day is a positive or negative integer representing the day of the month from 1 to 31.

 

YEAR

The YEAR function returns the year corresponding to a date. The year is returned as an integer in the range 1900-9999.

The syntax is:

YEAR(serial_number)

The serial_number is required. Dates should be entered by using the DATE function, or as results of other formulas or functions.

For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text.

Notes:

KiSSFLOW stores dates as sequential serial numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900.Values returned by the YEAR, MONTH and DAY functions will be Gregorian values regardless of the display format for the supplied date value. For example, if the display format of the supplied date is Hijri, the returned values for the YEAR, MONTH and DAY functions will be values associated with the equivalent Gregorian date.

 

MONTH

The MONTH function returns the month of a date represented by a serial number. The month is given as an integer, ranging from 1 (January) to 12 (December).

The syntax is:

MONTH(serial_number)

Serial_number is required. The date of the month you are trying to find. Dates must be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if you enter dates as text.

 

DAY

The DAY function returns the day of a date, represented by a serial number. The day is given as an integer ranging from 1 to 31.

The syntax is: 

DAY(serial_number)

Serial_number is required. The date of the day you are trying to find. Dates should be entered by using the DATE function, or as results of other formulas or functions.

 

NETWORKDAYS function

Dates are stored as simple integers and are formatted for display. Therefore, dates can be simply subtracted to calculate the number of days. However, there are requirements where the weekends must be excluded while calculating the difference between two dates (for example, a leave form). In this case, the NETWORKDAYS function can be used to calculate the dates difference excluding the weekends and holidays.

The NETWORKDAYS function returns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays. Use NETWORKDAYS to calculate employee benefits that accrue based on the number of days worked during a specific term.

The syntax is:

NETWORKDAYS(start_date, end_date, [holidays])

Holidays are an optional range of one or more dates to exclude from the working calendar, such as state and federal holidays and floating holidays. The list can be either a range of cells that contains the dates or an array constant of the serial numbers that represent the dates.

NOTE: Important Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2012,5,23) for the 23rd day of May, 2012. Problems can occur if dates are entered as text.

 

 

NETWORKHOURS function

The NETWORKHOURS function returns the number of hours between two work days. Working hours exclude weekends. The recommended field type is Number with 2 decimal places.

The syntax is:

NETWORKHOURS(start_datetime, end_datetime)

Did this answer your question?