topic Help For convert date, i need help urgent in QlikView

Help For convert date, i need help urgent

Fri, 18 Jun 2010 18:12:28 GMT

Hello my friends,

I have two dates, in my expression.

([26/10/2009 11:56:00] - 23/10/2009 9:32:00) = 3.08999999.

This dates is 2 results of sql, change according to the type of reference I use

I need to bring the result as follows, 3 days 2 hours and 24 minutes. And when you have case that less than one day, bring me 0 days, many hours. How do such conversion. Grateful

Help For convert date, i need help urgent

fernandotoledo — Fri, 18 Jun 2010 18:28:06 GMT

you can´t format a timestamp this way. You can make a two section stringlike

floor(X) & ' days ' & time(frac(x),'hh:mm')

Help For convert date, i need help urgent

Anonymous — Fri, 18 Jun 2010 18:38:04 GMT

Try interval function:
interval (timestamp1 - timestamp2, 'D hh:mm')

Help For convert date, i need help urgent

Fri, 18 Jun 2010 18:48:52 GMT

Hello friend, can do with the interval to run the maximum value, but I need to get the lower range of dates as well

Interval(MAX(DATA_PROD - DATA_BAIXA), 'D')&' Dias '&

hour

(MAX(DATA_PROD - DATA_BAIXA))&' Horas '&

minute

(MAX(DATA_PROD - DATA_BAIXA))&' Minutos '

day(sum(aggr(min((([DATA_PROD]) - ([DATA_BAIXA]))),CODIGO_ESTAGIO,REFERENCIA)))&' '& 'DIAS'&' '&

Hour

(sum(aggr(min((([DATA_PROD]) - ([DATA_BAIXA]))),CODIGO_ESTAGIO,REFERENCIA)))&' '& 'Horas'&' '&

Minute

(sum(aggr(min((([DATA_PROD]) - ([DATA_BAIXA]))),CODIGO_ESTAGIO,REFERENCIA)))&' '& 'Minutos'