DayName Calculation not Refreshing

[chevell]

Ok, I'm going nuts here. I've got a field called DayName that is a calculation. The calc is like this: DayName(Status(Current Date))

For some odd reason, it never shows the right day. The field is global and I am not storing the result. But for some stupid reason it shows "Tuesday". (Its currently Thursday.) I thought I needed to close it and reopen it but that changed nothing. I need this thing to updated daily so that when the dayname is "Monday" (12am monday morning) the database will execute a different script that the one it normally executes every 3 minutes.

Ideas?

[-Queue-]

Global calculations don't exist in version 6. Perhaps you are using an auto-enter calculation instead of a true calculation field?

[kenji]

I'm also confused about whether or not your DayName field is a global or a calculation.

Either way it seems like there's a way to solve this...

If you're running a script that checks the name of the current day of the week, you could set your global "DayName" with a script addition (or subscript) that would be:

Set Field ["DayName", "DayName(Status(CurentDate))"]

If you're using a calculation field try defining the calculation as = DayName(Status(CurrentDate))

Result is text and storage option "unstored".

This method will cause the field to change to the new day each time you move to a different record, create a new record or change the focus to the DayName field, etc. You do have to do something like the previous examples to cause it to recalculate this way.

It's a little troubling that the name of your field is also the name of a function, so you'll have to be careful about how it might work it's way into one of your calculations as either a function or a field reference unintentionally.

Anyway, I hope this helps.

MT

[chevell]

Ok, sorry, its not a global field. Its just a calculation that is unstored. My every-three-minute script checks this field and says if DayName = "Monday" then ... Should I be doing something different to get that DayName calculation to update? Thanks!

[-Queue-]

As kenji said, if you don't modify the current record somehow or move to another record, it won't update. You might be better off just using the calculation in the script. If [ DayName(Status(CurrentDate)) = "Monday" ]...