Skip to content
Infoveave Help

WEEKDAY

The WEEKDAY 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 day of the week as text (e.g., “Monday”, “Tuesday”, “Wednesday”, “Thursday”, “Friday”, “Saturday”, “Sunday”).

Remark

  • The WEEKDAY function helps analyze date-related data by breaking down days of the week. This is crucial for time-based data analysis and reporting.
  • The WEEKDAY function does not consider nulls or blanks.

Syntax

WEEKDAY(<expression>)

WEEKDAY in Calculated Columns

Write the WEEKDAY function. For instance

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

Example

Suppose you want to create a column that returns the weekday based on the column SALES DATE. You can use the WEEKDAY function as follows

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