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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
MalcolmCICWF
Creator III
Creator III

today() and now() Remove Timestamp

I am trying to use the today() or now() fuctions to tell a QVD to only reload an ADD_DATE  >= today(0) -90

Because of the times stamp it it is loading from that point of the day when I want it to load an even 90 days back starting from the beggining of the day, not from the timestamp. So, can I remove the timestamp or is there another way besides the functions I am using?

1 Reply
Miguel_Angel_Baeyens

Hi,

The following should work:

WHERE ADD_DATE >= Date(Today() -90);

Hope that helps.

Miguel