Publié Thu, 16 Dec 2021 17:06:20 GMT par 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,
 
Publié Thu, 16 Dec 2021 22:46:30 GMT par 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
Publié Fri, 17 Dec 2021 08:44:53 GMT par 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.