Hi,
I'm attempting to create a PDF report that includes a time filter, such as a start date and end date.
The timestamp column in my data is currently in the format of "Mon Feb 28 2022 11:45:11".
The values in the timestamp column are in the format of YYYY-MM-DD HH:MM:SS.
I've set up a filter using the following code:
FILTER "table"."column" >= TO_DATE({{13.Start_Date}},FORMAT( '%Y-%m-%d %H:%M:%S' ))
AND "table"."column" <= TO_DATE({{13.End_Date}},FORMAT( '%Y-%m-%d %H:%M:%S' ));
However, I'm still receiving an empty PDF report.
Could you please help me identify what I'm doing wrong?
Thank you.