topic today() and now() Remove Timestamp in QlikView

today() and now() Remove Timestamp

MalcolmCICWF — Wed, 12 Sep 2012 13:35:22 GMT

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?

Re: today() and now() Remove Timestamp

Miguel_Angel_Baeyens — Wed, 12 Sep 2012 13:42:10 GMT

Hi,

The following should work:

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

Hope that helps.

Miguel