Issue with DATEROLL PBCS

User_2I532

Hi All,

I am trying to roll the date 6 months back and using DATEROLL function.

e.g.

Open block(

"Sale Date" = @DATEROLL("Start Date",DP_MONTH,-6);

)

---

Details:

"Sale Date" and "Start Date" datatype is set as Date.

"Sale Date" = 6/1/2022

hoping to see "Start Date" = 1/1/2022

However, when I check Sale Date it is loaded with some random number. Any idea what I am doing wrong?

Thanks!