What I want to do is capture two different values in two other fields:
A) The number of days until that date is reached - changes dynamically (so that value will run down to 0 when 18/12/2024 is reached)
B) The number of days until that date is reached, at the time the record was added. So I can say that when that record was added to the system there were X days until the date was reached.
I saw that there was a getnetdays (from memory) or similar field that would not consider weekends. I’m therefore asking here for any help.
So I have a problem in that ADDED DATE is captured in with time in the date. Does anyone know how I can strip away time values so it will work by being compared to another simple date field.
@GSH, you can insert a new Date field that doesn’t capture time, and add a conditional rules that sets it to the value of the Date/Time field. You can do a similar thing with ‘time only’