Date input parameter in custom analytical query defaulting to "00000000"

[former_member751051]

Hello Experts,

I am building report using Custom Analytical Query app and i want date as optional input on my selection screen with no default value for it.

When i make date as user input filter then its value is defaulting to "00000000" which does not make sense.

I want to use it as filter but with blank value, can you please help here...

Thanks in advance,

Saurabh Hambardikar

[former_member577849]

Dear Saurabh Hambardikar,

Unfortunately, it seems to be taking longer than usual for your question to be answered. You might want to try an alternative route to speed things up.

Please check if a similar question has already been asked in the Community. We have found that sometimes questions that have been answered before are no longer receiving responses.

The easiest way to do this, is to visit the All Questions page and search for your specific topic.

You could also check the SAP Support Portal and search for SAP Notes, SAP Knowledge Base Articles and more.

Thanks,

Marvin

[JackGraus]

A date has data format num 8. So initial value is 00000000. If you want to check on initial value you need to check on 00000000 instead of blank.

Regards Jack

[peter_merenyi2]

Hi,

It seems to me that system uses '00000000' default value in the background and filter the result set even if filter value on filter screen left empty for that specific date field.

In other words, filters on date-type fields cannot be used as OPTIONAL but has to be filled with ANY value (e.g. an indefinite range).

Regards,

Peter

[former_member751051]

Hello Marvin,

Thanks for the reply. I did it but will try to search on community again if i can fine any lead on this.

Regards,

Saurabh