Hitachi Vantara Pentaho Community Wiki
Skip to end of metadata
Go to start of metadata

Returns the day of week of a date, an integer between 1 and 7.

Syntax

Summary: Extract the day of the week from a date; if text, uses current locale to convert to a date.
Syntax: WEEKDAY( DateParam Date [ ; IntegerType = 1 ] )
Returns: Number
Constraints: None
Semantics: Returns the day of the week from a date, as a number from 0 through 7. The exact meaning depends on the value of Type:

  1. When Type is 1, Sunday is the first day of the week, with value 1; Saturday has value 7.
  2. When Type is 2, Monday is the first day of the week, with value 1; Sunday has value 7.
  3. When Type is 3, Monday is the first day of the week, with value 0; Sunday has value 6.

Day of Week

Type=1 Result

Type=2 Result

Type=3 Result

Sunday

1

7

6

Monday

2

1

0

Tuesday

3

2

1

Wednesday

4

3

2

Thursday

5

4

3

Friday

6

5

4

Saturday

7

6

5

 

Examples

Syntax

Result

=WEEKDAY(DATEVALUE("6/21/69"))

7

=WEEKDAY(DATE(1900,1,1),1)

7

BDate = "6/21/69"
 
=WEEKDAY([BDate],1)

7

  • No labels