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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

DateTime Calculation

I want to add 100 secs to the datetime  for eg. 02/10/2014 5:40:08 PM so that it becomes 02/10/2014 5:41:48 PM. Any help is appreciated

1 Solution

Accepted Solutions
Not applicable
Author

Hi ramko,

try like this.....

timestamp(MyDate + 100/86400)

View solution in original post

6 Replies
Not applicable
Author

Hi ramko,

try like this.....

timestamp(MyDate + 100/86400)

Anonymous
Not applicable
Author

=Timestamp(now()+0.0011574074087548)

Anonymous
Not applicable
Author

this expression will give u 100 secs forward time

Anonymous
Not applicable
Author

replace now() by field name or variable name and you will get the answer

Anonymous
Not applicable
Author

when you add 1 it is 1 days

so you have to fraction it with 24 hours*60 Minutes*60Secs =86400

Not applicable
Author

Thank you so much.