inlunarweektodate - script and chart function

This function returns true if timestamp lies inside the part of the lunar week up to and including the last millisecond of base_date. Lunar weeks in QlikView are defined by counting 1 January as the first day of the week.

Syntax:  

InLunarWeekToDate (timestamp, base_date, period_no [, first_week_day])

Return data type: Boolean

Arguments:  

Argument Description
timestamp The date that you want to compare with base_date.
base_date Date that is used to evaluate the lunar week.
peroid_no The lunar week can be offset by period_no. period_no is an integer, where the value 0 indicates the lunar week which contains base_date. Negative values in period_no indicate preceding lunar weeks and positive values indicate succeeding lunar weeks.
week_start An offset that may be greater than or less than zero. This changes the beginning of the year by the specified number of days and/or fractions of a day.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?