*imaginative date picker

hey,

You can create a placeholder that writes to a variable like shown below, you won't have to create separate placeholders for Year, month, or day. One should be enough.

This is how it will look like:

Now this value is being written to a variable I created called ReportingDate.

You can now use this variable as a filter on a component or sheet level like this:

Filter AUFK.ERDAT>= <%=ReportingDate%>;

Hope this helps.

Dear Divya, I am thankful for your answers. I applied your directions as you can see in the pdf. However I got an error saying  "TO_DATE: The input column contains a string that does not conform to FORMAT %Y%m%d]. In this case, returning NULL instead. Affected string: s2020-01-01]." how can I debug, can you please help me?

you can follow our discussion

@Vildan Aslan @1460055742 @Esra Acikay 

Best,

Z

I solved with the following:

Filter ROUND_DAY("VIEW_AUFK"."ERDAT")>=  to_date(<%= Reporting_Date %>,FORMAT('%Y-%m-%d')) ;

That's great :)