Ad Hoc editor and week number

[Sokk]

Hey,

so I've gotten far enough to figure out that Ad Hoc editor does not have any direct function for weeknumbers (which baffles me as the system has a calendar) but has anyone figured out any non-tiresome way to calculated weeknumber for dates?

 

[bojan.brajkovic]

Hello,

You could use something like this, it utilizes the number of days and number of months functions.

Create calcualted field with following formula: Round((MonthNumber("Date_field") - 1) * 4.33 + DayNumber("Date_field") / 7)

Regards,
 

[Sokk]

Hey,

tested this formula but the values aren't quite correct. Would need something which brings weeknumbers with weeks going from monday to sunday.

Best regards,