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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
alextomlins
Contributor III
Contributor III

Current DateTime = Today() + now()

Hi Probably a really easy one -

In SQL there's a function to get the current DateTime. How do i do this in QlikSense. I've used Today() and i've used now but i need to get a timestampformat out of it or a numerical - something i can work with eitherway

Thanks,

Alex

3 Replies
sunny_talwar
MVP
MVP

What format do you get when you use Now()? You can change to TimeStamp(Now()) or Num(Now())

alextomlins
Contributor III
Contributor III
Author

Oh sorry i forgot! now() is DateTime - I thought it was just the timestamp.

Thank you !   That has really helped me

sunny_talwar
MVP
MVP

No problem