Hello,
I have a very simple question, but have not been able to find an answer (maybe because its clear to everyone but me): I have a report with two date columns:
"Contact"."Contact Created Date/Time" and "Contact Custom Obj 9"."Date Created"
And the thing I need is to apply a filter where it shows only the lines where the dates from the first column are equal to the dates in the second one.
I understand the way is probably via SQL syntax, but my basic sql logic doesnt apply here, since I am not pulling out data from database, but only filtering.
And, do I need to modify the date format by using CAST ..... AS DATE or is it enough to have the dates adjusted in the "data format" tab?
I am grateful for any help