Hello everyone, 

First of all thanks for any help. 
I am trying to build a report, that will show me a list of orders shipped. I have the orders informations, but I would need the report to only show data shipped based on the timestamp. The timestamp is in the format of dd mm yyyy hh:mm:ss. 
I would need the filter to show everything shipped each day, without having a specified date, something like CURRENT_DATE. I tried a filter like in the attached picture, but I get an error. Losing my marbles here, because I am pretty sure it's a simple conversion of data, SOMEHOW, that I don't know. 

Any help is much appreciated. Thank you.

Hi Victor,

The <contains> operator is meant for character data, it is mapped to the <like> operator.
You could try something like: 
cast ( <your ship timestamp> as date) = current_date

Henk, thanks a million, I will try that. Someone showed me how to insert a prompt, and by selecting Interval date / time in the prompt, it runs the report as I need it as well. Its not the automated filter that I was hoping for, but it does the job.

I will surely try the CAST option as well to see if it eliminates the need for date selection from my prompt.