Week number

How can I get the week number of any date?

Hi Vorawooth Quang,<br> <br> in arithmetic expressions in the workflow designer you can use the DatePart function explained here:&#160;<a href="https://learn.microsoft.com/en-us/dotnet/api/microsoft.visualbasic.dateandtime.datepart">DateAndTime.DatePart Method</a>.<br> For a list of all available functions, please see the Knowledge center <a href="https://help.docuware.com/#/home/64352/2/2">here</a>.<br> <br> Hope that helps.<br> <br> Greetings from Germany,<br> Simon H. Hellmann<br> DocuWare System Consultant

Sorry, but I can't manage to make the DatePart function working.

Hi&#160;Vorawooth,<br> <br> you are almost there. The DatePart() function returns a Variant (Integer). That means you can write the returned value to a field/variable of type &quot;numeric&quot; in DocuWare Workflows.<br> <br> I suppose you are trying to write to a field/variable of type &quot;text&quot;. For this you need to convert the returned value to a string using CStr().<br> So the expression looks like this:&#160;<code>CStr(DatePart(&quot;ww&quot;, GV_Date1))</code><br> <br> <br> Viele Grüße / With best regards,<br> --<br> Gerardo Lisanti<br> Product Manager &#160;| &#160;DocuWare GmbH

Hi Gerardo,<br> <br> Thank you for your help! It works perfectly now.&#160;