- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 30, 2020 05:33 AM
Hi, I would like to divide my week number field by 2 in order to group time entry by pay period. Our pay period is two weeks starting on sundays.
Here is the formula I use to get the week number: DATETIME_FORMAT(Date,‘w’)
And here is the formula I use in the pay period field: {# semaine}/2
I get #ERROR! in all the cell of the pay period field.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 30, 2020 06:23 AM
Precisely. :winking_face:
This is the expected behaviour when you try to divide a string. You either need to use the WEEKNUMBER() function to derive the weeks as number values, or you need to convert # semaine into a number before attempting to divide it.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 30, 2020 08:49 AM
Thank you so much.
I used the WEEKNUMBER() function and I was then able to divide it by 2.
