Sysdate Causing Issues

There are many ways to do this One other way is to use a Julian date as a reference point and comparing this to today. You can then calculate the number of days, weeks, months e.t.c. I outlined this approach here:-

https://bobj-board.org/t/139560


Mak 1 :uk: (BOB member since 2005-01-06)