Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

TIMESTAMP BACK

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

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

see the screen shot.

Hope it helps.

Goos luck!

Rainer

View solution in original post

4 Replies
maneshkhottcpl
Partner - Creator III
Partner - Creator III

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

Not applicable
Author

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')

Not applicable
Author

Hi,

see the screen shot.

Hope it helps.

Goos luck!

Rainer

Not applicable
Author

It worked perfectly

thanks a lot!