I am trying to add this filter its throwing error, can u please elaborate a little?

The FilterFromDate and FilterToDate should be your filter variables, in this case both DateTime types.

The AddedOnColumn should be renamed to your actual EntityColumn name.

After these changes, what are the errors you are receiving?

Perhaps provide a sample OML (save module, and add it here as reply)

As I see in your screenshot, your AddedOn column is of type DateTime, therefor filtering should be done with DateTime type filters. However, your filter screenshot shows only dates. Your filters should then use the function DateToDateTime:

The FromDate filter:

FilterFromDate = NullDate() or AddedOnColumn >= DateToDateTime(FilterFromDate)

And the ToDate filter:

FilterToDate = NullDate() or AddedOnColumn < DateToDateTime(AddDays(FilterToDate,1))

Explanation of the AddDays: When you want to have the whole day included in the ToDate filter (23:59:59). As seen in the above filter: It adds one day to the selected ToDate filter, converts that to a full datetime (with 00:00:00 time component) and compares it with the AddedOnColumn.

its not even filtering anything, it giving me empty table, is it necessary to create from and to date as an attribute in the entity 

I have used local variables to point this values.

The date filter inputs need to point to the local variables.

Without other screenshots it is difficult to solve this.

Here is a sample OML, maybe you can see anything you can use from it.

Could you provide a (simplified) OML to me that I can view?

Thanks!!!! Its working