Week number

How can I get the week number of any date?

Hi Vorawooth Quang,

in arithmetic expressions in the workflow designer you can use the DatePart function explained here: DateAndTime.DatePart Method.
For a list of all available functions, please see the Knowledge center here.

Hope that helps.

Greetings from Germany,
Simon H. Hellmann
DocuWare System Consultant

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

Hi Vorawooth,

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 "numeric" in DocuWare Workflows.

I suppose you are trying to write to a field/variable of type "text". For this you need to convert the returned value to a string using CStr().
So the expression looks like this: CStr(DatePart("ww", GV_Date1))


Viele Grüße / With best regards,
--
Gerardo Lisanti
Product Manager  |  DocuWare GmbH

Hi Gerardo,

Thank you for your help! It works perfectly now.