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!