Date difference

[ThinhDinh]

So the TRUNC math column solution in the other thread works?

Extracting from an array

Ok here’s my proposed solution. [CleanShot 2025-03-06 at 06.25.29] From the array, use this to get the array length. [CleanShot 2025-03-06 at 06.25.38] Use this to calculate the date difference between the start date and now: TRUNC(N-D) [CleanShot 2025-03-06 at 06.25.58] Use this to calculate the index of the “current day”: MAX(MOD(D,C),0) [CleanShot 2025-03-06 at 06.26.28] And finally this to get the number of the day via the index. [CleanShot 2025-03-06 at 06.26.50]