Publicado Thu, 16 Dec 2021 17:06:20 GMT por 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,
 
Publicado Thu, 16 Dec 2021 22:46:30 GMT por Jacob Eaton
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
Publicado Fri, 17 Dec 2021 08:44:53 GMT por 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.