Skip to main content
Solved

Creating an imanitave DatepickerI want to put a filter to my KPI whose start date is 01-01-2022 and end date is 31-12-2022. I want to do it by using my placeholder inputs not by using a date picker. Can I filter related dates by not using a date

  • April 19, 2023
  • 5 replies
  • 9 views
Z
Level 8

Date picker's SAP information is "AUFK"."ERDAT".

Assuming 01,01,2022 for a,b,c and 31,12,2022 for d,e,f .MicrosoftTeams-image (30)

Best answer by zeliha.otgöz

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: [2020-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')) ;

    5 replies

    Z
    Level 8
    • zeliha.otgöz
    • Author
    • Level 8
    • April 19, 2023

    *imaginative date picker

    D
    Level 4

    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.

    image.pngThis is how it will look like:

    image 

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

     

    image 

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

     

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

     

    Hope this helps.

     

    Z
    Level 8
    • zeliha.otgöz
    • Author
    • Level 8
    • April 24, 2023

    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.

    image.pngThis is how it will look like:

    image 

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

     

    image 

    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: [2020-01-01]." how can I debug, can you please help me?

    you can follow our discussion

    @Vildan Aslan @1460055742 @Esra Acikay 

    Best,

    Z

    1 Attachments
    Z
    Level 8
    • zeliha.otgöz
    • Author
    • Level 8
    • Answer
    • April 24, 2023

    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: [2020-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')) ;

    D
    Level 4

    That's great :)

    Community Code of ConductAccessibility statement