Dream Writer Data Selection Dates

[HeyJoeFiel]

Hello,

I'm doing a DW that is based on a file that have a date field. I need use this date field with the last day of the prev month in my Data Selection. I know that there are values such as *MONTH, *DAY, *YEAR, but none of them work. Anyone know how I do it ?

Thanks a lot.

Matheus Costa

 

[Matt S]

Matheus:

I recently did this myself.
I wrote another program (attached) that reads backwards through the F00365 file then updates the data selection.

For this to work, the DREAM Writer already needs something in the data selection written over the date. This process only changes the date. This particular code actually changes the from and through range for the date.

I added the call to the attached program in the CL program after it calls P98CLOPT.