Post

3 followers Follow
0
Avatar

Using Today() function in a custom field

How to use Today() function in a formula-based custom field?

I am getting an error - not in context

Roei Danieli Answered

Please sign in to leave a comment.

3 comments

0
Avatar

What are you trying exactly to do with your formula?

Can you share your current code?

Guy 0 votes
Comment actions Permalink
0
Avatar

Hi Roei,

Did you manage to resolve this?

I've got a similar use case. 

 

Darren 0 votes
Comment actions Permalink
0
Avatar

Hello,

I see 2 workarounds for this:

- If your formula doesn't use any other fields (just "hardcoded" values), you can create a new Scheduled Workflow rule that will run every day (at 1 A.M. for example) to update the value the way you want. Maybe you could lock the value if you set the custom field to be editable through API or workflow only

- If your formula uses other fields, create a new custom field C_TODAY at the workitem level (or maybe the organisation level, if you can access this field with your formula), and use the Scheduled Workflow rule to set that value every day. Then, just use that field in your formula based custom field.

Hope that helps,

Armand BOLMONT 0 votes
Comment actions Permalink