How To Generate Date's Based on YYYYMM eg(201911)

[kalisetty-saite]

Hi Guys your help will be appreciated I had Column called as Month which has the Year and Month Data as 201911

Now i need to generate all Dates for the Nov Month of 2019. 

[StarinieriG]

Hi,

try something like this

TABLE:
LOAD
Date#(date,'YYYYMM') AS date

from ...;

Inner Join
LOAD
date,
Date(MakeDate(Year(date),Month(date),1)+IterNo()-1) as DATE
Resident TABLE
While Month(MakeDate(Year(date),Month(date),1)+IterNo()-1)=Month(date);

[kalisetty-saite]

Hi Thx For The Code i tried but it's not working  app is getting hanged while refreshing can you share sample QVW

Thanks for ur response and support

[StarinieriG · Accepted solution]

Hi,

here the attached

[kalisetty-saite]

Thanks StarinieriG Solution is working