Skip to content
Infoveave Help

WEEKNUM

The WEEKNUM function in Infoveave returns the day of the week as text for a given date.

Applicable to

Calculated Columns

Return Value

The function returns the week number of the date as an integer value.

Remark

  • The WEEKNUM function helps analyze date-related data by breaking down the week number, crucial for time-based data analysis and reporting.
  • The WEEKNUM function does not consider nulls or blanks.

Syntax

WEEKNUM(<expression>)


WEEKNUM in Calculated Columns

Write the WEEKNUM function. For instance

WEEKNUM(<expression>)
  1. Replace <expression> with the start period. You can also call in @StartDate and @EndDate function.
  2. To learn how to add calculated columns in Infoveave, visit the section Calculated Columns.

Example

Suppose you want to create a column that returns the week number based on the column SALES DATE, you can use the WEEKNUM function as follows

WEEKNUM(DATEVALUE(VALUE([Sales Date])))