Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Today - function isn't working

Status
Not open for further replies.

184

Programmer
Mar 29, 2007
2
AT
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
 
Is this possible because of the fact that the system date doesn't have any affect if you're not working on the server but on a terminal?
 
I'm not a hardware expert but I recall in the past that sometimes the bios date didn't match the OS date. I forget but it happened way back in windows 98.

-Laughter works miracles.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top