How to filter numeric field by wildcard ?

[former_member339940]

Hi all

I would like to ask you how I can use wildcard to filter data from timestamp or numeric field. When I use the input for filter data from timestamp field, for example '12.02.2016*' I get error message "Wildcard are not allowed for numerical fields". Do you have any idea how I can resolve this issue ?
Thank you in advance.

[horst_keller]

Are you sure, you are dealing with timestamps in output format directly? Where are you filtering and what?

I'm afraid that you are mixing up external and internal data formats.

Before going on you should gain some understanding of how data are stored and presented and then think about how to apply filters. In ABAP this involves data types, conversion and comparison rules.

[raghug]

On a selection screen, and depending on the conversion exit used (for example conversion routine TSTPS used in domain LCA_TIMESTAMP), you might have to use the formatted date and time according to user settings. So that would be 12.02.2016 00:00:00 to 12.02.2016 23:59:59.

[matt]

If you're dealing with timestamps then put a range in. 20160212000000 to 20160212235959