I need to take a 'StringValue' and convert it to a number on the fly. the stringvalue in question hold s a EPOCH date.
Once converted I need to take the timestamp value and subtract the above.
The value of the above then needs writing to a new field that I can reference.
I'm aware that scripted fields need to be of type number, but can I use a number stored withing a StringValue to ultimately give the new metric I'm after?