Created on 08 November 2020
icon_unfollowing
Login to follow
date-time-utils

Date time Utils

icon_trusted
Stable version 1.0.4 (Compatible with OutSystems 11)
Uploaded on 07 December 2022 by 
date-time-utils

Date time Utils

Documentation
1.0.4

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



1.0.3

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
  • 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






Support options
This asset is not supported by OutSystems. You may use the discussion forums to leave suggestions or obtain best-effort support from the community, including from  who created this asset.
Dependencies
Date time Utils has no dependencies.