topic Re: What does floor(Today()) do ? in QlikView

What does floor(Today()) do ?

Mon, 13 Oct 2014 13:33:45 GMT

Hi All,

I have a dashboard in which the creator has used the following script statement

Load

T_End-(floor(today())) as NoOfDaystoEndDate,
*;

I thought 'floor' was used for rounding down, and Today() for returning today's date. The statement doesn't make sense.

Can someone please explain what is happening ?

Thanks

Re: What does floor(Today()) do ?

Colin-Albert — Mon, 13 Oct 2014 13:37:29 GMT

floor() rounds a value down to the nearest integer.

For date-time fields, floow will remove the time portion so just the date part is used.

The script is calculating the difference between today's date

and T_End

Assuming that T_End is a date.

perhaps the command should be

floor( T_End - today() ) as NoOfDaystoEndDate

Re: What does floor(Today()) do ?

alexandros17 — Mon, 13 Oct 2014 13:39:40 GMT

Floor(Today()) returns the same of (Num(Today()) so convert the date in its numerical representation, in this case nothing else because there is not time part ...

Re: What does floor(Today()) do ?

Mon, 13 Oct 2014 14:06:57 GMT

Thanks both. That makes sense now. I never thought of the time element.