# filter on form datasource

**URL:** <https://www.dynamicsuser.net/t/filter-on-form-datasource/40904>\
**Category:** Technical Forum\
**Created:** [October 16, 2012, 1:00pm UTC](https://www.dynamicsuser.net/t/filter-on-form-datasource/40904 "2012-10-16T13:00:26Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![K.manish](https://avatars.discourse-cdn.com/v4/letter/k/a8b319/32.png) [@K.manish](https://www.dynamicsuser.net/u/K.manish)\
**Post date:** [October 16, 2012, 1:00pm UTC](https://www.dynamicsuser.net/t/filter-on-form-datasource/40904/1 "2012-10-16T13:00:26Z")

</div>

HI Friends

I am creating a from with D as datasource. the table D has a display method which returns Date. Now i want to filter the form where this display method has date = todaysdate.

how to add range on display method on datasource.

how to do this.

thanks

Manish

---

<div class="post-metadata">

**Author:** ![ThomasP](https://avatars.discourse-cdn.com/v4/letter/t/ba9def/32.png) [@ThomasP](https://www.dynamicsuser.net/u/ThomasP)\
**Post date:** [October 16, 2012, 1:35pm UTC](https://www.dynamicsuser.net/t/filter-on-form-datasource/40904/2 "2012-10-16T13:35:52Z")

</div>

Hi,

It’s not possible to filter/add a range on a display method

Hope it helps

Regards,

Thomas

---

<div class="post-metadata">

**Author:** ![K.manish](https://avatars.discourse-cdn.com/v4/letter/k/a8b319/32.png) [@K.manish](https://www.dynamicsuser.net/u/K.manish)\
**Post date:** [October 16, 2012, 5:41pm UTC](https://www.dynamicsuser.net/t/filter-on-form-datasource/40904/3 "2012-10-16T17:41:52Z")

</div>

hi Thomas ,

Is there any other way to do this?

---

<div class="post-metadata">

**Author:** ![kki.krish](https://avatars.discourse-cdn.com/v4/letter/k/ce7236/32.png) [@kki.krish](https://www.dynamicsuser.net/u/kki.krish)\
**Post date:** [October 18, 2012, 10:08am UTC](https://www.dynamicsuser.net/t/filter-on-form-datasource/40904/4 "2012-10-18T10:08:59Z")

</div>

hi manish

use query’s

this.query().addatasourceNo().filednum(tablename,fieldname).addrange(sysquery::…)

using this query u can get the range value

regrds,

kris