# Get the dates out of an datefilter

**URL:** <https://www.dynamicsuser.net/t/get-the-dates-out-of-an-datefilter/9388>\
**Category:** Developers Forum\
**Created:** [November 19, 2004, 7:33am UTC](https://www.dynamicsuser.net/t/get-the-dates-out-of-an-datefilter/9388 "2004-11-19T07:33:08Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![jensthomsen](https://avatars.discourse-cdn.com/v4/letter/j/c77e96/32.png) [@jensthomsen](https://www.dynamicsuser.net/u/jensthomsen)\
**Post date:** [November 19, 2004, 7:33am UTC](https://www.dynamicsuser.net/t/get-the-dates-out-of-an-datefilter/9388/1 "2004-11-19T07:33:08Z")

</div>

With help from Codeunit 1 I have stored a datefilter in a variabel (it is not a variabel in a table!). Is there any easy way to get the starting- and stopping dates out of the filter? I.e if the filter looks like 12.12.03…12.12.04 I want 2 new variables Date1 and Date2 containing: Date1 = 12.12.03 Date2 = 12.12.04 I guess COPYSTR would work…

---

<div class="post-metadata">

**Author:** ![asramaboy](https://avatars.discourse-cdn.com/v4/letter/a/f04885/32.png) [@asramaboy](https://www.dynamicsuser.net/u/asramaboy)\
**Post date:** [November 19, 2004, 7:50am UTC](https://www.dynamicsuser.net/t/get-the-dates-out-of-an-datefilter/9388/2 "2004-11-19T07:50:05Z")

</div>

Hi Jensthomsen, Pls see the build in function call “GETRANGEMAX” and “GETRANGEMIN”.

---

<div class="post-metadata">

**Author:** ![fhoozemans](https://avatars.discourse-cdn.com/v4/letter/f/43a26b/32.png) [@fhoozemans](https://www.dynamicsuser.net/u/fhoozemans)\
**Post date:** [November 19, 2004, 7:52am UTC](https://www.dynamicsuser.net/t/get-the-dates-out-of-an-datefilter/9388/3 "2004-11-19T07:52:35Z")

</div>

I have coded it like this, gvDateFilter := xxx.GETFILTER(Date); gvFilterFrom := COPYSTR(gvDateFilter, 1, 8); gvFilterTo := COPYSTR(gvDateFilter, 11, 8); EVALUATE(gvDateFrom, gvFilterFrom); EVALUATE(gvDateTo, gvFilterTo); gvFilterFrom and gvFilterTo are datatype TEXT gvDateFrom and gvDateTo are datatype DATE Hope this helps. Fred

---

<div class="post-metadata">

**Author:** ![jensthomsen](https://avatars.discourse-cdn.com/v4/letter/j/c77e96/32.png) [@jensthomsen](https://www.dynamicsuser.net/u/jensthomsen)\
**Post date:** [November 19, 2004, 8:00am UTC](https://www.dynamicsuser.net/t/get-the-dates-out-of-an-datefilter/9388/4 "2004-11-19T08:00:00Z")

</div>

Hi Chee As far as I understand these 2 only works on fields in a record, and my “problem” is, that my Datefilter is stored in a Global Variabel!

---

<div class="post-metadata">

**Author:** ![sander7](https://avatars.discourse-cdn.com/v4/letter/s/f17d59/32.png) [@sander7](https://www.dynamicsuser.net/u/sander7)\
**Post date:** [November 19, 2004, 8:00am UTC](https://www.dynamicsuser.net/t/get-the-dates-out-of-an-datefilter/9388/5 "2004-11-19T08:00:19Z")

</div>

Hi Jens, The GETRANGEMIN and GETRANGEMAX will do the trick. With a litle work-around. e.g. Define a record-variable: RecVar - record - G/L Account RecVar.SETFILTER(“Date Filter”,YourVariable); IF RecVar.GETRANGEMIN(“Date Filter”) \<\> ‘’ THEN Date1 := RecVar.GETRANGEMIN(“Date Filter”); IF RecVar.GETRANGEMAX(“DateFilter”) \<\> ‘’ THEN Date2 := RecVar.GETRANGEMAX(“Date Filter”); regards, Alexander