topic Re: select dates 31 days months, 30 days and leap year in Visualization and Usability

select dates 31 days months, 30 days and leap year

karunaramteke — Fri, 15 Jan 2021 09:05:46 GMT

Hi all,

please help to get the following,

For 31 days : date from 17th to 31st Oct'20 to be considered only.

For 30 days months : Date from 16th to 30th to be considered.

for February : in leap year 15th to 29th, while in non-leap year 14th to 28th to be considered.

Please help me to get this or if any link is there by which I can get help.

Thank you in advance

Re: select dates 31 days months, 30 days and leap year

karunaramteke — Fri, 15 Jan 2021 10:25:54 GMT

Hi all,

Anyone can help me it this.

Re: select dates 31 days months, 30 days and leap year

MayilVahanan — Fri, 15 Jan 2021 11:15:57 GMT

Hi @karunaramteke

Try like below

LET vDMNoOfYear =6;
LET vMaxDate = Num(Today()-1);
LET vMinDate = Num(YearStart(AddYears(Today(), -($(vDMNoOfYear)))));

Load *,
If(Month(CalDate)='Feb',
If(mod(Year(CalDate),4) = 0 and mod(Year(CalDate),100) <> 0 or mod(Year(CalDate),400) = 0,
if(Day(CalDate)>14,1), If(Day(CalDate)>13,1)),
if(Match(Month(CalDate), 'Jan', 'Mar', 'May', 'Jul', 'Aug', 'Oct', 'Dec'),
If(Day(CalDate)>16,1),
If(Day(CalDate)>15, 1))) as Flag,
Year(CalDate) as Year,
Day(CalDate) as Day,
Month(CalDate) as Month;
LOAD
Date($(vMinDate) + IterNo()-1) as CalDate
AutoGenerate 1
While $(vMinDate) + IterNo()-1 <= $(vMaxDate);

Select Flag and verify the values.. You can use flag in ur set analysis.
Or instead of Flag, u can create another date field also.

Its depends on ur requirements.