Hi all, a newhire in netsuite currently under training. They gave me this as assignment but couldnt find similar cases in NLCorp. Tried searching in SA but it’s pointing to script? I havent tried scripting yet at this point. Can someone elaborate further the scenario and do I need script for this or is there a workaround?

Formula(text) wont work with those fields as they seem to be date/numeric fields.