Skip to main content

 

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.

Be the first to reply!

Reply