Posted Thu, 16 Dec 2021 17:06:20 GMT by Jalila Manal
Hello,

How do I extract the year from the document date?

I've tried to put the following arithmetic expression on the workflow : Year(WD_Document date), but this does not work (I can not even click on OK).
Thanks in advance.

Regards,
 
Posted Thu, 16 Dec 2021 22:46:30 GMT by Jacob Eaton Software Integration Specialist
You may have the right expression. The function Year(DateTime) returns an Integer. Make sure your variable or index is compatible with that data type or convert it to a string, with CStr(Year(DateTime)).

Thanks,
Jacob Eaton
Posted Fri, 17 Dec 2021 08:44:53 GMT by Jalila Manal

Hi Jacobs,

That was the issue indeed. It worked now, thank you very much.

Best Regards,

You must be signed in to post in this forum.