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

RoundFloor

Presentation

Example

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 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 datetime rounded down to the nearest interval.
Not available.

Example

ResArrondi = RoundFloor(-16.238167,2) // Renvoie -16.24
ResArrondi = RoundFloor(3.9) // Renvoie 3 (pas de décimales)
ResArrondi = RoundFloor(3.999,2) // Renvoie 3.99
ResArrondi = RoundFloor(1.9) // Renvoie 1
ResArrondi = RoundFloor(-1.9) // Renvoie -2

New in version 28

// Arrondi d'une Durée
ResArrondiDurée is Duration
ResArrondiDurée = RoundFloor(13 min, 5 min) // Renvoie 10 min (0001000000)
// La durée est découpée en périodes de 5 minutes.
// Le résultat correspond au début de la période qui contient la durée 13 min.

New in version 28

// Arrondi d'une DateHeure
dhMonDateHeure is DateTime = "202211041524"
Trace("dhMonDateHeure: " + dhMonDateHeure)
Trace("ArrondiInférieur: " + RoundFloor(dhMonDateHeure, 7 min))
// Affiche 20221104152400000

// La journée est découpée en périodes de 7 min.
// Dans cet exemple, la variable dhMonDateHeure correspond à l'arrondi inférieur

Syntax

Calculate the lower rounding of a numerical value 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

Calculate the lower rounding of a Duration for a given interval Hide the details

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

<Result>: Duration

Duration corresponding to the beginning of the given interval.

<Duration used>: Duration

Duration to be rounded:
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

Period taken into account for the calculation of the lower rounding:
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

Calculate the lower rounding of a DateTime for a given interval Hide the details

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

<Result>: DateTime

DateTime corresponding to the start of the given interval.

<Manipulated DateTime>: DateTime

Date and time to be rounded.

<Interval>: Duration

Period taken into account for the calculation of the lower rounding:
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 the real numbers is "." (dot).

Business / UI classification: Neutral code

Component: wd280mat.dll