Forum Discussion
Get the Date difference between values
Hi, how can I get de date difference between documents numbers from the same Name? I'm trying to identify the time the Company Name did the last Sales Order. Could someone help me? It Can be on...
The output should be the number os days of difference. The date on my example is all 10/03/2023 because all of these orders are from today.
I do not understand your example, what VAR __Current = [Value] is? Greg_Deckler
JEM_Systems That just grabs the row's current value of the Value column and stores it in a variable. Subtracting two dates gives back the number of days since a date is just an integer of the number of days since 12/30/1899. If necessary, you can force it to be a number with a RETURN of this:
(__Current - __Previous) * 1.