• No replies
6184 Posts

Pinned topic WTX Extract function to return records between a date range

‏2013-01-25T16:10:29Z |
I am attempting to return a set of records where the date (Date Fields:Record:AcctGroup) is greater than or equal to a date(3StartDateTag:BDX) that I am passing like this:

=f_bALANCE(EXTRACT(Record:AcctGroup, DATETONUMBER(3StartDateTag:BDX) > DATETONUMBER(Date Fields:Record:AcctGroup)))

The EXTRACT function works great when I use "=" but when I use ">=" or ">" the maps builds but returns the value from the first record not the record that is ">=" several records down.

Any help would be appreciated.