Assign week

Hi All,

I'm looking to auto assign a week value based on a user provided date. We're trying to assign a value between 1 and 52 based on a predetermined date range. For example, January 1 - 7 is week 1 and so on. Has anyone successfully implemented something like this before? I'm looking at a workflow with an arithmetic expression, but am not making any headway. Any feedback or advice would be greatly appreciated.

Hi,
Looks like you should you use datetime VB functions in a WF
https://learn.microsoft.com/en-us/dotnet/api/microsoft.visualbasic?view=netcore-3.1
Best regards

Thank you, Gilles. I'm working on something in the arithmetic expressions of an assign data workflow, but the commands are somewhat limited. I have viable visual basic code, but can't simplify it to the point that DocuWare can read it. Is there any other way to add the code?

Hi Jon Sproule, 

according to the Workflow Expression Parser Documentation, you can use DatePart(Interval, DateTime, [FirstDayOfWeek], [FirstWeekOfYear]) for this.
Example: 
GV_MyDateTime = 26.04.2022 11:30
DatePart("ww", GV_MyDateTime)
Returns: 18

Hope this helps.

Greetings from Germany,
Simon H. Hellmann
DocuWare System Consultant

Thank you, Simon. I will take a look at this in more detail.