PHpierre
asked on
Dynamic "Today" value.
Hi,
I test your solution and this does not work. The calculated column was created, it does not "refresh" the value "Today" each day. My formula is "=[Today]" and it's not dynamic. The value date is is fixing on creation date of the calculated column.
See joint a ScreenShot.
ScreenShot.GIF
I test your solution and this does not work. The calculated column was created, it does not "refresh" the value "Today" each day. My formula is "=[Today]" and it's not dynamic. The value date is is fixing on creation date of the calculated column.
See joint a ScreenShot.
ScreenShot.GIF
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes, i am agree with you but you don't reply to the question's forum.
Question's forum :
"I need to create a Calculated column (calculation based on other columns) in a SharePoint Issue Tracking List. This calculated column needs to use a formula based on today's date i.e. Days Overdue=IF([Submit Date]>0,"",IF(Today>[Due Date],Today-[Due Date],"")). The Today value needs to be dynamic, in other words refresh/update every day, not be static. When you enter the Today value in the formula, SharePoint returns an error message that states "Calculated columns cannot contain volatile functions like Today and Me". I need a work around for this. "
I need that the calculated column contains the value "Today" is refreshed automatily every days.
How to resolve this probleme?
Congratulation,