Forum Stats

  • 3,814,706 Users
  • 2,258,900 Discussions
  • 7,892,809 Comments

Discussions

Issue with DATEROLL PBCS

User_2I532
User_2I532 Member Posts: 1 Green Ribbon

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!

Tagged: