# 日期和时间函数 QlikView 日期和时间函数用于变换和转换日期和时间值。所有函数都可用于加载脚本和图表表达式。 这些函数基于日期-时间序列号（等于从 1899 年 12 月 30 日开始的天数）。整数部分表示天数，分数部分表示一天的时间。 QlikView 使用该参数的数值，所以数字即使没有格式化为日期或时间，也可以作为参数的有效值。例如，如果参数与数值不对应（因为它是一个字符串），则 QlikView 会尝试根据日期和时间环境变量解释此字符串。 如果在参数中使用的时间格式与环境变量设置不一致，QlikView 将不会做出正确的解释。要解决此问题，可更改设置或使用解释功能。 在每个函数的示例中，假设默认的时间和日期格式为 hh:mm:ss 和 YYYY-MM-DD (ISO 8601)。 信息注释 使用日期或时间函数处理时间戳时，QlikView 忽略任何夏令时参数，除非日期或时间函数包含地理位置。 例如，`ConvertToLocalTime( filetime('Time.qvd'), 'Paris')` 将使用夏令时参数，而 `ConvertToLocalTime(filetime('Time.qvd'), 'GMT-01:00')` 将不使用夏令时参数。 使用每个函数的下拉列表可查看每个函数的简短描述和语法。单击语法描述中的函数名称可了解更多信息。 ### 时间的整数表达式 [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### second 此函数用于根据标准数字解释当 expression 小数部分被解释为时间时返回一个表示秒的整数。 [**second**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/second.htm)(expression) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### minute 此函数用于根据标准数字解释当 expression 小数部分被解释为时间时返回一个表示分钟的整数。 [**minute**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/minute.htm)(expression) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### hour 此函数用于根据标准数字解释当 expression 小数部分被解释为时间时返回一个表示小时的整数。 [**hour**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/hour.htm)(expression) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### day 此函数用于根据标准数字解释当 expression 小数部分被解释为日期时返回一个表示某天的整数。 [**day**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/day.htm)(expression) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### week 此函数用于返回根据 ISO 8601 表示周数的整数。周数根据标准数字解释通过表达式的日期解释进行计算。 [**week**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/week.htm)(timestamp [, first\_week\_day [, broken\_weeks [, reference\_day]]]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### month 此函数用于返回包含在环境变量 MonthNames 中定义的月份名称的对偶值和一个介于 1 至 12 的整数。月份根据标准数字解释通过表达式的日期解释进行计算。 [**month**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/month.htm)(expression) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### year 此函数用于根据标准数字解释当 expression 被解释为日期时返回一个表示年份的整数。 [**year**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/year.htm)(expression) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### weekyear 此函数用于返回根据 ISO 8601 周数所属的年份。星期数范围在 1 和大约 52 之间。 [**weekyear**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/weekyear.htm)(expression) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### weekday 此函数用于返回包含以下名称的对偶值： 在环境变量 DayNames 中定义的日期名称。 介于 0-6 之间的整数对应于一周 (0-6) 的标定天。 [**weekday**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/weekday.htm)(date) ### Timestamp 函数 [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### now 此函数用于返回系统时钟的当前时间的时间戳。默认值为 1。 [**now**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/now.htm)([ timer\_mode]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### today 此函数用于返回系统时钟的当前日期。 [**today**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/today.htm)([timer\_mode]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### LocalTime 此函数用于返回指定时区的系统时钟的当前时间戳。 [**localtime**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/localtime.htm)([timezone [, ignoreDST ]]) ### Make 函数 [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### makedate 此函数用于返回根据年份 YYYY、月份 MM 和日期 DD 计算的日期。 [**makedate**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/makedate.htm)(YYYY [ , MM [ , DD ] ]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### makeweekdate 此函数用于返回根据年份 YYYY、星期 WW 和星期几 D 计算的日期。 [**makeweekdate**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/makeweekdate.htm)(YYYY [ , WW [ , D ] ]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### maketime 此函数用于返回根据小时 hh、分钟 mm 和秒 ss 计算的时间。 [**maketime**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/maketime.htm)(hh [ , mm [ , ss [ .fff ] ] ]) ### 其他日期函数 [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### AddMonths 此函数用于返回在 startdate 后 n 个月内发生的日期，或者如果 n 为负数，则用于返回 startdate 前 n 个月内发生的日期。 [**addmonths**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/addmonths.htm)(startdate, n , [ , mode]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### AddYears 此函数用于返回在 startdate 后 n 年内发生的日期，或者如果 n 为负数，则用于返回 startdate 前 n 年内发生的日期。 [**addyears**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/addyears.htm)(startdate, n) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### yeartodate 此函数用于判断输入日期是否在最后加载脚本的日期的年份以内，并返回 True（如果在）或返回 False（如果不在）。 [**yeartodate**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/yeartodate.htm)(timestamp [ , yearoffset [ , firstmonth [ , todaydate] ] ]) ### Timezone 函数 [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### timezone 此函数根据 Windows 的定义返回当前时区的名称，不考虑日光节约时间调整。 [**timezone**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/timezone.htm)( ) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### GMT 此函数返回来自系统时钟和 Windows 时间设置的日期和当前 Greenwich Mean Time。 [**GMT**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/GMT.htm)( ) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### UTC 返回日期和当前 Coordinated Universal Time。 [**UTC**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/UTC.htm)( ) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### daylightsaving 用于返回如 Windows 所定义的当下为日间省时的调整。 [**daylightsaving**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/daylightsaving.htm)( ) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### converttolocaltime 将 UTC 或 GMT 时间戳转换为本地时间作为对偶值。此地方可为全世界任何一个城市和时区。 [**converttolocaltime**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/converttolocaltime.htm)(timestamp [, place [, ignore\_dst=false]]) ### 设置时间函数 [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### setdateyear 该函数获取 timestamp 和 year 的输入，并使用输入中指定的 year 更新 timestamp 。 [**setdateyear**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/setdateyear.htm) (timestamp, year) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### setdateyearmonth 该函数获取 timestamp、month 和 year 的输入，并使用输入中指定的 year 和 month 更新 timestamp 。 [**setdateyearmonth**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/setdateyearmonth.htm) (timestamp, year, month) ### In... 函数 [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### inyear 此函数用于返回 True，如果 timestamp 位于包含 base\_date 的年份以内。 [**inyear**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/inyear.htm)(date, basedate , shift [, first\_month\_of\_year = 1]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### inyeartodate 此函数用于返回 True，如果 timestamp 位于包含 base\_date 为止以及包括 base\_date 最后毫秒的年份部分以内。 [**inyeartodate**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/inyeartodate.htm) (date, basedate , shift [, first\_month\_of\_year = 1]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### inquarter 此函数用于返回 True，如果 timestamp 位于包含 base\_date 的季度以内。 [**inquarter**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/inquarter.htm) (date, basedate , shift [, first\_month\_of\_year = 1]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### inquartertodate 此函数用于返回 True，如果 timestamp 位于包含 base\_date 为止以及包括 base\_date 最后毫秒的季度部分以内。 [**inquartertodate**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/inquartertodate.htm) (date, basedate , shift [, first\_month\_of\_year = 1]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### inmonth 此函数用于返回 True，如果 timestamp 位于包含 base\_date 的月份以内。 [**inmonth**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/inmonth.htm)(date, basedate , shift) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### inmonthtodate 用于返回 True，如果 timestamp 位于包含 base\_date 为止以及包括 base\_date 最后毫秒的月份部分以内。 [**inmonthtodate**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/inmonthtodate.htm) (date, basedate , shift) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### inmonths 此函数用于查找时间戳是否在作为基准日期的同一个月、两个月、季度、四个月或半年内。另外，它也可以用于判断时间戳是否位于上一个或下一个时间周期以内。 [**inmonths**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/inmonths.htm)(n, date, basedate , shift [, first\_month\_of\_year = 1]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### inmonthstodate 此函数用于判断时间戳是否位于截止以及包括 base\_date 的最后毫秒的某个月、两个月、季度、四个月或半年周期的一部分以内。另外，它也可以用于判断时间戳是否位于上一个或下一个时间周期以内。 [**inmonthstodate**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/inmonthstodate.htm) (n, date, basedate , shift [, first\_month\_of\_year = 1]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### inweek 此函数用于返回 True，如果 timestamp 位于包含 base\_date 的星期以内。 [**inweek**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/inweek.htm)(date, basedate , shift [, weekstart]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### inweektodate 此函数用于返回 True，如果 timestamp 位于包含 base\_date 为止以及包括 base\_date 最后毫秒的星期部分以内。 [**inweektodate**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/inweektodate.htm) (date, basedate , shift [, weekstart]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### inlunarweek 如果 timestamp 位于包含 base\_date 的阴历周之内，则此函数返回 True。QlikView 中的阴历周将 1 月 1 日定义为一周的第一天。 [**inlunarweek**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/inlunarweek.htm) (date, basedate , shift [, weekstart]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### inlunarweektodate 如果 timestamp 位于截止且包括 base\_date 最后毫秒的阴历周的某部分之内，则此函数返回 True。QlikView 中的阴历周将 1 月 1 日定义为一周的第一天。 [**inlunarweektodate**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/inlunarweektodate.htm) (date, basedate , shift [, weekstart]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### inday 此函数用于返回 True，如果 timestamp 位于包含 base\_timestamp 的一天以内。 [**inday**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/inday.htm)(timestamp, basetimestamp , shift [, daystart]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### indaytotime 此函数用于返回 True，如果 timestamp 位于包含 base\_timestamp 为止以及包括 base\_timestamp 精确毫秒的日子部分以内。 [**indaytotime**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/indaytotime.htm)(timestamp, basetimestamp , shift [, daystart]) ### Start ... end 函数 [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### yearstart 此函数用于返回与包含 date 的年份的第一天的开始对应的时间戳。默认的输出格式为在脚本中所设置的 DateFormat。 [**yearstart**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/yearstart.htm)( date [, shift = 0 [, first\_month\_of\_year = 1]]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### yearend 此函数用于返回与包含 date 的年份的最后一天的最后毫秒时间戳对应的值。默认的输出格式为在脚本中所设置的 DateFormat。 [**yearend**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/yearend.htm)( date [, shift = 0 [, first\_month\_of\_year = 1]]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### yearname 此函数用于返回一个四位数年份的显示值，带有与包含 date 的年份的第一天的第一毫秒时间戳对应的基本数值。 [**yearname**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/yearname.htm)(date [, shift = 0 [, first\_month\_of\_year = 1]] ) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### quarterstart 此函数用于返回与包含 date 的季度的第一毫秒的时间戳对应的值。默认的输出格式为在脚本中所设置的 DateFormat。 [**quarterstart**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/quarterstart.htm)(date [, shift = 0 [, first\_month\_of\_year = 1]]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### quarterend 此函数用于返回与包含 date 的季度的最后毫秒的时间戳对应的值。默认的输出格式为在脚本中所设置的 DateFormat。 [**quarterend**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/quarterend.htm)(date [, shift = 0 [, first\_month\_of\_year = 1]]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### quartername 此函数用于返回一个显示值，该值显示季度的月（根据 MonthNames 脚本变量的格式）以及年，伴随一个与该季度第一天第一毫秒的时间戳对应的基础数值。 [**quartername**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/quartername.htm)(date [, shift = 0 [, first\_month\_of\_year = 1]]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### monthstart 此函数用于返回与包含 date 的月份的第一天的第一毫秒时间戳对应的值。默认的输出格式为在脚本中所设置的 DateFormat。 [**monthstart**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/monthstart.htm)(date [, shift = 0]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### monthend 此函数用于返回与包含 date 的月份的最后一天的最后毫秒时间戳对应的值。默认的输出格式为在脚本中所设置的 DateFormat。 [**monthend**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/monthend.htm)(date [, shift = 0]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### monthname 此函数用于返回一个显示值，该值显示该月（根据 MonthNames 脚本变量的格式）以及年，伴随一个与该月第一天第一毫秒的时间戳对应的基础数值。 [**monthname**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/monthname.htm)(date [, shift = 0]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### monthsstart 此函数用于返回与包含基准日期的一个月、两个月、季度、四个月或半年的第一毫秒的时间戳对应的值。另外，它也可以用于判断上一个或下一个时间周期的时间戳。 [**monthsstart**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/monthsstart.htm)(n, date [, shift = 0 [, first\_month\_of\_year = 1]]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### monthsend 此函数用于返回与包含基准日期的一个月、两个月、季度、四个月或半年的最后毫秒的时间戳对应的值。另外，它也可以用于判断上一个或下一个时间周期的时间戳。 [**monthsend**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/monthsend.htm)(n, date [, shift = 0 [, first\_month\_of\_year = 1]]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### monthsname 此函数用于返回一个显示值，表示时段各月份（根据 MonthNames 脚本变量的格式）和年的范围。基础数值与包含基准日期的一个月、两个月、季度、四个月或半年的第一毫秒的时间戳对应。 [**monthsname**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/monthsname.htm)(n, date [, shift = 0 [, first\_month\_of\_year = 1]]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### weekstart 此函数用于返回与包含 date 的日历周的第一天（周一）的第一毫秒时间戳对应的值。默认输出格式是在脚本中设置的 DateFormat。 [**weekstart**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/weekstart.htm)(date [, shift = 0 [,weekoffset = 0]]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### weekend 此函数用于返回与包含 date 的日历周的最后一天（周日）的最后一毫秒时间戳对应的值。默认的输出格式为在脚本中所设置的 DateFormat。 [**weekend**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/weekend.htm)(date [, shift = 0 [,weekoffset = 0]]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### weekname 此函数用于返回一个值，显示带有与包含 date 的周的第一天的第一毫秒时间戳对应的基本数值对应的年份和周数。 [**weekname**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/weekname.htm)(date [, shift = 0 [,weekoffset = 0]]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### lunarweekstart 此函数用于返回与包含 date 的阴历周的第一毫秒的时间戳对应的值。QlikView 中的阴历周将 1 月 1 日定义为一周的第一天。 [**lunarweekstart**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/lunarweekstart.htm)(date [, shift = 0 [,weekoffset = 0]]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### lunarweekend 此函数用于返回与包含 date 的阴历周的最后毫秒的时间戳对应的值。QlikView 中的阴历周将 1 月 1 日定义为一周的第一天。 [**lunarweekend**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/lunarweekend.htm)(date [, shift = 0 [,weekoffset = 0]]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### lunarweekname 此函数用于返回一个显示值，显示与包含 date 的阴历周的第一天的第一毫秒时间戳对应的年份和阴历周数。QlikView 中的阴历周将 1 月 1 日定义为一周的第一天。 [**lunarweekname**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/lunarweekname.htm)(date [, shift = 0 [,weekoffset = 0]]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### daystart 此函数用于返回与 time 参数中包含的一天的最后毫秒时间戳对应的值。默认的输出格式为在脚本中所设置的 TimestampFormat。 [**daystart**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/daystart.htm)(timestamp [, shift = 0 [, dayoffset = 0]]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### dayend 此函数用于返回与 time 中包含的一天的最后毫秒的时间戳对应的值。默认的输出格式为在脚本中所设置的 TimestampFormat。 [**dayend**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/dayend.htm)(timestamp [, shift = 0 [, dayoffset = 0]]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### dayname 此函数用于返回一个值，显示与包含 time 当天第一毫秒的时间戳对应的基本数值的日期。 [**dayname**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/dayname.htm)(timestamp [, shift = 0 [, dayoffset = 0]]) ### Day numbering 函数 [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### age age 函数用于返回某人在 date\_of\_birth 出生的 timestamp（完整年份）时的年龄。 [**age**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/age.htm)(timestamp, date\_of\_birth) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### networkdays networkdays 函数用于返回工作日的编号（周一至周五），在 start\_date 和 end\_date 之间，并将任何列出的可选 holiday考虑在内。 [**networkdays**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/networkdays.htm) (start:date, end\_date {, holiday}) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### firstworkdate firstworkdate 函数用于返回最近的起始日以获得 no\_of\_workdays（周一至周五），它不迟于 end\_date，并已将任何列出的可选节假日考虑在内。end\_date 和 holiday 应是有效的日期或时间戳。 [**firstworkdate**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/firstworkdate.htm)(end\_date, no\_of\_workdays {, holiday} ) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### lastworkdate lastworkdate 函数用于返回最早的结束日以获得 no\_of\_workdays（周一至周五），如果在 start\_date 开始考虑任何列出的可选 holiday。start\_date 和 holiday 应是有效的日期或时间戳。 [**lastworkdate**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/lastworkdate.htm)(start\_date, no\_of\_workdays {, holiday}) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### daynumberofyear 此函数用于计算时间戳所属的年份的天数。从该年度的第一天的第一毫秒开始计算，但可以偏移第一个月。 [**daynumberofyear**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/daynumberofyear.htm)(date[,firstmonth]) [](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm) #### daynumberofquarter 此函数用于计算时间戳所属的季度的天数。 [**daynumberofquarter**](https://help.qlik.com/zh-CN/qlikview/September2025/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/daynumberofquarter.htm)(date[,firstmonth])