Login to follow
Date time Utils

Date time Utils (ODC)

Stable version 1.0.4 (Compatible with ODC)
Uploaded on 19 March 2024 by OutSystems Champions
Date time Utils

Date time Utils (ODC)

Documentation
1.0.4

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