Hello,
Is it possible to create a configurable column between the current system date and an existing date element?
Here is the latest syntax I have tried which throws an error for an unexpected '(' unless I remove the last ')' in which case it just displays the text:
VALUE(DateToNumber(object.Schedule().DaemonControllerSchedule().LogManager().CurrentTime().Format('M2/D2/yy'))-
DateToNumber(object.astype(MaterialExternalSupply).MaterialExternalSupplyProperty().pdat().Format('M2/D2/yy')))
The DateToNumber method does not seem to be valid in configurable columns, but if I remove that part, the result just displays the first date minus the second date (i.e. dd/mm/yy - dd/mm/yy) instead of the difference in days. Is this type of calculation even possible in configurable columns, or does it have to be modelled into one of the objects? In the web-based support pages, it is difficult to discern what functions/methods are supported in configurable columns and which are just for designers/developers.
Thanks
