topic Re: subtract 1 day from timestamp in QlikView

subtract 1 day from timestamp

agni_gold — Sun, 23 Mar 2014 17:54:47 GMT

hi,

11/12/2011 12:00:00 AM

is time i want result like

11/11/2011 12:00:00 AM

its_anandrjs — Sun, 23 Mar 2014 18:11:47 GMT

Hi,

Use add months

Hope this helps

Thanks & Regards

its_anandrjs — Sun, 23 Mar 2014 18:21:56 GMT

Hi,

Use like =AddMonths(Datefield,-1)

Hope this helps

Thanks & Regards

agni_gold — Sun, 23 Mar 2014 18:28:05 GMT

My format is MM/DD/YY

and i want to subtract 1 day from date only .

maxgro — Sun, 23 Mar 2014 18:30:12 GMT

=date(date#('11/12/2011 12:00:00 AM', 'MM/DD/YYYY hh:mm:ss TT') - 1, 'MM/DD/YYYY hh:mm:ss TT')

its_anandrjs — Sun, 23 Mar 2014 18:38:18 GMT

Hi,

Do like this

Temp;

LOAD Date(Datem,'MM/DD/YYYY HH:MM:SS TT') AS Datem;

LOAD * Inline

[

Datem

11/12/2011 12:00:00 AM

];

And then in front end do this in any chart

=Date(Datem-1,'MM/DD/YYYY')

Hope this helps

Thanks & Regards