topic converting timestamp into decimal in QlikView

converting timestamp into decimal

Tue, 23 Aug 2011 18:11:33 GMT

Need help please, converting a timestamp into a decimal for comparison reasons.

Is there a function that will convert a timestamp field (MM/DD/YYYY hh:mm) into a decimal?

In my script, this statement results in MinDate becoming a decimal:

MIN([Staff Start Date and Time]) As MinDate ... via a left join.

Now, I need to compare the [Staff Start Date and Time] to see if it equals the MinDate and need to first convert it to the same format as MinDate.

Tue, 23 Aug 2011 18:55:23 GMT

I found the answer.

Num([Staff Start Date and Time]) As OriginalDate

Will convert the timestamp field into a decimal.

its_anandrjs — Tue, 23 Aug 2011 18:58:07 GMT

Hi,

It convert it into number, as you say you want to see decimal place the date column.

Anand

its_anandrjs — Tue, 23 Aug 2011 19:03:21 GMT

Hi,

You need to round it to certain decimal places if you required it.

Regards

Anand