daysBetween function returning wrong value for me.
Hi, I have a requirement where I need to create a report to calculate a total sales by Brand/Product for 30days/60days/90days.
I am trying to create a custom column for 30days/60days/90days calculation. So prior I want to find the difference between the sales order date using function daysBetween($currentDate,timestamp("2019-04-20")) but I am not getting the appropriate result.
Can some one help me with the steps to achieve this.