today() and now() Remove Timestamp

[MalcolmCICWF]

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?

[Miguel_Angel_Baeyens]

Hi,

The following should work:

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

Hope that helps.

Miguel