RoundFloor (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / WLanguage functions / Standard functions / Numeric values management functions / Math functions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

RoundFloor (Function)

In french: ArrondiInférieur

Warning
From version 28, RoundDown is kept for backward compatibility. This function is replaced by RoundFloor.

Returns:

the numeric value rounded down to the nearest integer.
New in version 28
the duration rounded down to the nearest interval.
Not available.
New in version 28
the date and time rounded down to the nearest interval.
Not available.

Example

ResRound = RoundFloor(-16.238167,2) // Returns -16.24
ResRound = RoundFloor(3.9) // Returns 3 (no decimal)
ResRound = RoundFloor(3.999,2) // Returns 3.99
ResRound = RoundFloor(1.9) // Returns 1
ResRound = RoundFloor(-1.9) // Returns -2

New in version 28

// Rounded Duration
ResRoundedDuration is Duration
ResRoundedDuration = RoundFloor(13 min, 5 min) // Returns10 min (0001000000)
// The duration is divided into 5-minute periods.
// The result is the start of the time range that contains 13 min.

New in version 28

// Rounded DateTime variable
dtMyDateTime is DateTime = "202211041524"
Trace("dtMyDateTime: " + dtMyDateTime)
Trace("RoundDown: " + RoundDown(dtMyDateTime, 7 min))
// Displays 20221104152400000

// The day is divided into 7-minute periods.
// In this example, the dtMyDateTime variable is rounded down to the nearest value

Syntax

Rounding a numeric value down Hide the details

<Result> = RoundFloor(<Numeric value> [, <Number of decimals>])

<Result>: Integer or real

Value rounded to the lower 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.

New in version 28

Not available

Rounding a duration down in a given interval Hide the details

<Result> = RoundFloor(<Duration used> , <Interval>)

<Result>: Duration

Duration corresponding to the start 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 down:
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).

New in version 28

Not available

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

<Result> = RoundFloor(<DateTime handled> , <Interval>)

<Result>: DateTime

DateTime variable corresponding to the start of the given interval.

<DateTime handled>: DateTime

Date and time to be rounded.

<Interval>: Duration

Time period taken into account to round the duration down:
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: wd280mat.dll