topic INYEARTODATE? in QlikView

INYEARTODATE?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Can any one gie the easy example for inyeartodate

what is 0 or -1 year how it works

I checked help files its bit confusing for me ?

Thanks in advance

Re: INYEARTODATE?

Gysbert_Wassenaar — Mon, 07 Mar 2016 14:17:39 GMT

0 and -1 are the numeric values of the boolean false and true values.

From the help file:

InYearToDate (date, basedate , shift [, first_month_of_year = 1])

returns true if date lies inside the part of year containing basedate up until and including the last millisecond of basedate. The year can be offset by shift. Shift is an integer, where the value 0 indicates the year which contains basedate. Negative values in shift indicate preceding years and positive values indicate succeeding years. If you want to work with (fiscal) years not starting in January, indicate a value between 2 and 12 in first_month_of_year.

Examples:

inyeartodate ( '2006-01-25', '2006-02-01', 0 ) returns true

inyeartodate ( '2006-01-25', '2006-01-01', 0 ) returns false

inyeartodate ( '2005-01-25', '2006-02-01', -1 ) returns true

Can you tell us which of the examples from the help you don't understand?

Re: INYEARTODATE?

Anonymous — Mon, 07 Mar 2016 15:56:34 GMT

inyeartodate ( '2006-01-25', '2006-02-01', 0 ) returns true

inyeartodate ( '2006-01-25', '2006-01-01', 0 ) returns false

can u give explination on this

Re: INYEARTODATE?

Gysbert_Wassenaar — Mon, 07 Mar 2016 17:03:10 GMT

inyeartodate ( '2006-01-25', '2006-02-01', 0 ) returns true

The base date is 2006-02-01. So the year-to-date period is 2006-01-01 to 2006-02-01. The date 2006-01-25 lies within that period so the inyeartodate function returns true

inyeartodate ( '2006-01-25', '2006-01-01', 0 ) returns false

The base date is 2006-01-01. So the year-to-date period is 2006-01-01 to 2006-01-01. The date 2006-01-25 lies outside that period so the inyeartodate function returns false.