ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage functions / Standard functions / Numeric values functions / Math functions
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Warning
From version 28, RoundUp is kept for backward compatibility. This function is replaced by RoundCeil.
Returns:
  • the numeric value rounded up to the nearest integer.
  • the duration rounded up to the nearest interval.
    WEBDEV - Server codePHP Not available.
  • the date and time rounded up to the nearest interval.
    WEBDEV - Server codePHP Not available.
Example
ResRound = RoundCeil(-16.238167, 2) // Returns -16.23
ResRound = RoundCeil(3.1) // Returns 4 (no decimal)
ResRound = RoundCeil(3.111, 2) // Returns 3.12
ResRound = RoundCeil(1.9) // Returns 2
ResRound = RoundCeil(-1.9) // Returns -1
// Rounded Duration
ResRoundedDuration is Duration
ResRoundedDuration = RoundCeil(13 min, 5 min) // Returns 15 min (0001500000)
// The duration is divided into 5-minute periods.
// The result is the end of the time range that contains 13 min.
// Rounded DateTime variable
dtMyDateTime is DateTime = "202211041524"
Trace("dtMyDateTime: " + dtMyDateTime)
Trace("RoundCeil: " + RoundCeil(dtMyDateTime, 7 min))
// Displays 20221104153100000
 
// The day is divided into 7-minute periods.
Syntax

Rounding a numeric value up Hide the details

<Result> = RoundCeil(<Numeric value> [, <Number of decimals>])
<Result>: Integer or real
Value rounded to the greater number.
<Numeric value>: Real or currency
Numeric value to round.
<Number of decimals>: Optional integer
Number of decimals to return. No decimal is returned if this parameter is not specified.
WEBDEV - Browser codePHP Not available

Rounding a duration up in a given interval Hide the details

<Result> = RoundCeil(<Duration used> , <Interval>)
<Result>: Duration
Duration corresponding to the end of the given interval.
<Duration used>: Duration
Duration to round:
  • Duration variable containing the duration in "+DHHMMSSCCC" format (D corresponds to the number of days, HH to hours, MM to minutes, SS to seconds and CCC to milliseconds).
  • Duration in a readable format (e.g., 1 d 2 h 3 min 10 s 10 ms).
<Interval>: Duration
Time period taken into account to round the duration up:
  • Duration variable containing the duration in "+DHHMMSSCCC" format (D corresponds to the number of days, HH to hours, MM to minutes, SS to seconds and CCC to milliseconds).
  • Duration in a readable format (e.g., 1 d 2 h 3 min 10 s 10 ms).
WEBDEV - Browser codePHP Not available

Rounding a DateTime variable up in a given interval Hide the details

<Result> = RoundCeil(<DateTime handled> , <Interval>)
<Result>: DateTime
DateTime variable corresponding to the end of the given interval.
<DateTime handled>: DateTime
Date and time to be rounded.
<Interval>: Duration
Time period taken into account to round the duration up:
  • Duration variable containing the duration in "+DHHMMSSCCC" format (D corresponds to the number of days, HH to hours, MM to minutes, SS to seconds and CCC to milliseconds).
  • Duration in a readable format (e.g., 1 d 2 h 3 min 10 s 10 ms).
Remarks
The decimal separator for real numbers is "." (point).
Business / UI classification: Neutral code
Component: wd290mat.dll
Minimum version required
  • Version 16
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/28/2023

Send a report | Local help