WEEK- FineBI Help Document FineBI Document

Recent Updates: April 04, 2022

1. Extracted data

1）Overview

Syntax	WEEK(serial_number,"F1"/"F7")	Returns a number representing the week of the year.
Parameter1	serial_number	Represents the date entered. It can also be a series number, such as in a 1900 date system, where January 1, 1998 is stored as a series number of 35796.
Parameter2	"F1"/"F7"	F1 means the beginning of the week on Monday, F7 means the beginning of the week on Sunday. Note: It is possible to set the start of the week to Sunday or Monday in the middle of the decision-making platform week. If you do not enter F1 or F7 , the default value is F7.

Syntax

WEEK(serial_number,"F1"/"F7")

Returns a number representing the week of the year.

Parameter1

serial_number

Represents the date entered. It can also be a series number, such as in a 1900 date system, where January 1, 1998 is stored as a series number of 35796.

Parameter2

"F1"/"F7"

F1 means the beginning of the week on Monday, F7 means the beginning of the week on Sunday.

Note: It is possible to set the start of the week to Sunday or Monday in the middle of the decision-making platform week. If you do not enter F1 or F7 , the default value is F7.

2）Precautions

The WEEK(serial_number,"F1"/"F7") parameter is allowed to be empty. If the parameter is empty, the value is the WEEK of the year corresponding to the server time of the current system.
The first parameter default date or text type, the second parameter default text.
The second parameter supports both case.

3）Example

Formula	Result	Remark
WEEK()	52	The system server time is 2010-1-1 15:36:25.
WEEK("2010/1/1")	52
WEEK("2010/1/1","F1")	1
WEEK("2010/1/6")	1
WEEK(35796)	52

2. Real-time data

1）Overview

Syntax	WEEK(serial_number)	Returns a number representing the week of the year
Parameter	serial_number	Represents the date entered. Note: Only text and date types are supported.

Syntax

WEEK(serial_number)

Returns a number representing the week of the year

Parameter

serial_number

Represents the date entered.

Note: Only text and date types are supported.

2）Precautions

The WEEK(serial_number) parameter is allowed to be empty. If the parameter is empty, the value is the WEEK in a year corresponding to the server time of the current system.
You can use a default date, or a text-type parameter.

3）Example

Formula	Result	Remark
WEEK()	52	The system server time is 2010-1-1 15:36:25.
WEEK("2010-01-01")	52
WEEK("2010-01-06")	1

Already the First

Already the Last

Helpful
Not helpful
Only read

售前咨询电话

400-811-8890转1

在线技术支持

在线QQ：800049425

热线电话：400-811-8890转2

总裁办24H投诉

热线电话：173-1278-1526

文档反馈

鼠标选中内容，快速反馈问题

鼠标选中存在疑惑的内容，即可快速反馈问题，我们将会跟进处理。

不再提示

10s后关闭

WEEK

1. Extracted data

2. Real-time data

Attachment List