Status
Tech review

Style guide




Short descriptionReturns the date part of timestamp represented by numeric value t in time_zone time zone.
Output




The function returns the date part of timestamp represented by numeric value t in time_zone.


 datePart(number t, timeZone time_zone) #Output: Number



Parser expressionDescription
timestamp March, 25th 2011 23:15

The function returns a representing date March, 25th 2011 00:00 in milliseconds.



Parameters used in this function

ParameterInput (data type)Description
timestamp

The parameter must be valid timestamp. Usually this value is retrieved from a field (e.g. due date, created date).
numberOfDays

The number defined here will be the offset in days. 

Negative values are used to substract days.

Internally JWT multiplies this value with the time macro  {DAY} to add full days to the timestamp. Learn more about time macros.

timeZone

The time zone used for the calculation. 



Work days might depend on the time zone - it might be Sunday on the west coast of the US while at the same time it's already Monday in Australia. 



The function returns a .