Okay,
first of all i want to mention I tried all the blogs i found, nothing did work properly. That's the situation i've got:
List Ticketting:
Startdate: (can be any date, even in the past or future)
Enddate: (can be any date, but has to be later than startdate)
All works great. But now i want to say how many days that have been passed since the startdate, using the [Today]-function.
So i've done this:
- made a new Today column (single text)
- made a new (Numeric or Date (tried them both))column, saying in the formula: "=[Today]-[Startdate]".
- deletet the Today column
All okay, he gives the right period that has passed since the beginning.
BUT when i change the system date, it doesn't change with it. I've done the following things:
- recreated and deletet the Today column
- edited all the items without changing anything (even when i change something it doesn't update my date).
What is it that I do wrong?
Greets,
Bram Segers
Programming-analyst
first of all i want to mention I tried all the blogs i found, nothing did work properly. That's the situation i've got:
List Ticketting:
Startdate: (can be any date, even in the past or future)
Enddate: (can be any date, but has to be later than startdate)
All works great. But now i want to say how many days that have been passed since the startdate, using the [Today]-function.
So i've done this:
- made a new Today column (single text)
- made a new (Numeric or Date (tried them both))column, saying in the formula: "=[Today]-[Startdate]".
- deletet the Today column
All okay, he gives the right period that has passed since the beginning.
BUT when i change the system date, it doesn't change with it. I've done the following things:
- recreated and deletet the Today column
- edited all the items without changing anything (even when i change something it doesn't update my date).
What is it that I do wrong?
Greets,
Bram Segers
Programming-analyst