Products Resources Support About Us

Rocket Software

Date range selection not working with MV'd dates in version 11.3.1 of Universe

When using a date range selection of an attribute that has different Multi-valued dates, we are getting ‘bad’ results. This used to work. Here is an example:

Filename… Pathname… Type Modulo

DICT CLC.TEST D_CLC.TEST 18 1
DATA CLC.TEST CLC.TEST 18 101

DICT SHIP.DT

0001 D
0002 1
0003 D2-
0004 SHIP.DT
0005 8R
0006 M

LIST CLC.TEST SHIP.DT 11:41:00am 11 Dec 2019 PAGE 1
CLC.TEST… SHIP.DT.

REC1 11-27-19
11-04-19
11-27-19
REC2 11-27-19
11-04-19
11-27-19
REC3 11-28-19
11-04-19
11-28-19

3 records listed.

.X6
06 SELECT CLC.TEST WITH SHIP.DT >=“11.27.19” AND WITH SHIP.DT<=“11.27.19”

3 record(s) selected to SELECT list #0.

’REC3’ should not have been selected. Help?

SHIP.DT contains multi values.
Try this:
SELECT CLC.TEST WITH SHIP.DT >=“11.27.19” AND WHEN SHIP.DT<=“11.27.19”

replace WITH with WHEN