topic TIMESTAMP BACK in QlikView

TIMESTAMP BACK

Fri, 07 Jan 2011 13:40:51 GMT

Hello,

I'm working with a timestamp format 'DD/MM/YYYY H:MM:SS' and I need to go back 30 days keeping the same format.

Once I used the following expression to go back 30 days but using a date format 'DD/MM/YYYY':

{<DATE={">=$(=date(only(DATE)-30)) <$(=only(DATE))"}>}

Is there any similar expression to do the same with a timestamp format??

Regards

maneshkhottcpl — Fri, 07 Jan 2011 13:50:46 GMT

Hi, Can u explain ur problem more? or send the sample application. i will surly help u.

Fri, 07 Jan 2011 14:15:03 GMT

Hi,

if the timestamp is '23/12/2010 22:55:35' i need to go exactly 30 days back ('23/11/2010 22:55:35')

Fri, 07 Jan 2011 14:55:21 GMT

Hi,

see the screen shot.

Hope it helps.

Goos luck!

Rainer

Fri, 07 Jan 2011 15:32:35 GMT

It worked perfectly

thanks a lot!