Forums
Home / Plugin: Calculated Fields Form / Weeknum in Month
(@graicifyd)
1 year, 7 months ago
How can I use ‘WEEKNUM(x,y)‘ to find the position of a week’s day in a month rather than in a year?
For example, is the 26th of April the first, second, third or fourth week in April?
(@codepeople)
Hello @graicifyd
There is no operation to calculate the week number in the month. You must calculate it yourself. But the process is as simple as
CEIL(DAY(fieldname1, 'dd/mm/yyyy')/7)
Best regards.
Thank you.