Using A Field Value As An Operator In A Calculation

[James Gill]

I'm just curious if this is possible. Say if I have a calculation that is asking

get (CurrentDate) = get (CurrentDate)

and the results is 1.



If I have a field that contains the literal text "=", can I substitue that value as an calculation operator like this?

if ( get (CurrentDate) & RandomField & get (CurrentDate) ; 1 ; 0 )

and get 1 as the result?

Is this the correct method to accomplish something along these lines? I'm basically wanting to allow the user to create their own custom calculations without needing a developer to do this for them.

[comment]

Use the Evaluate() function.

[James Gill]

Thanks, that works perfectly!