Date Time Utils provide an extensive list of client and server-side date time functions, that can be used on your logic or on any given expression:

• Date
  • Date_Max: Returns the maximum between two dates
  • Date_Min: Returns the minimum between two dates
• DateTime
  • DateTime_Ceiling: Rounds the date time up to a given interval in minutes (e.g. 9:12, with 15min interval = 9:15)
  • DateTime_ConvertUnixToDateTime: Converts date time in unix format to date time
  • DateTime_DiffMilliseconds: Returns the difference of milliseconds between two date times with milliseconds. Returns a positive number if DateTimeWithMs2 is greater than DateTimeWithMs1.
  • DateTime_Floor: Rounds the date time down to a given interval in minutes (e.g. 9:12, with 15min interval = 9:00)
  • DateTime_GetCurrDateTimeWithMilliseconds: Returns current date time with milliseconds with milliseconds on UTC
  • DateTime_GetUnix: Get Unix value for current timestamp
  • DateTime_GetUTC: Get datetime in UTC
  • DateTime_Max: Returns the maximum between two date times
  • DateTime_Min: Returns the minimum between two date times
• Days
  • Days_DateDiffBusinessDays: Returns the number of business days between two dates
  • Days_DateDiffWeekendsDays: Returns the number of weekend days between two dates
•  Month
  • Month_DateDiff: Returns difference in months between two dates (positive number if date 2 greater than date 1; negative number if date 1 greater than date 0)
  • Month_End: Gets the end of the month given date
  • Month_Start: Gets the start of the month given date
• Quarter
  • Quarter_DateDiff: Returns difference in quarter between two dates (positive number if date 2 greater than date 1; negative number if date 1 greater than date 0)
  • Quarter_End: Gets the end of the quarter given date
  • Quarter_Start: Gets the start of the quarter given date
• Week
  • Week_DateDiff: Returns difference in weeks between two dates (positive number if date 2 greater than date 1; negative number if date 1 greater than date 0)
  • Week_GetFirstDayOfTheWeekByDate: Gets first day of the week of the week of the given date
  • Week_GetFirstDayOfWeekByWeekNumber: Get week's first day given week number
  • Week_GetLastDayOfTheWeekByDate: Gets least day of the week of the week of the given date
  • Week_GetLastDayOfWeekByWeekNumber: Get week's last day given week number
  • Week_GetWeekDayByDate: Get week day given date
  • Week_GetWeekNumberByDate: Get week number given date
• Year
  • Year_DateDiff: Returns difference in years between two dates (positive number if date 2 greater than date 1; negative number if date 1 greater than date 0)
  • Year_End: Gets the end of the year given date
  • Year_Start: Gets the start of the year given date