Date derive as YYYYMM from the date field

[Raggs]

I have a date as below 

From date

01-01-2019

01-09-2019

I need the date field as below given

From date
201901
201902
201903
201904
201905
201906
201907
201908
201909
201910
201911
201912

Can any one help me on this on urgent basis...

Thanks in advance 

[Vegar]

Try this:

LOAD 
Date(date#([From Date], 'DD-MM-YYYY'), 'YYYYMM') as [From Date]
FROM ...

[Raggs]

Hey Vegar, Thnaks for your reply, 

However its not working.. we are getting null values... 

[Raggs]

I have used below

Text(left(Date(MD_FromDate,'YYYYMMDD'),'6')) as MD_FDate_YYYYMM,

for this I am getting as below 

but, I need the values with iteration of all months like below listed.

From date
201901
201902
201903
201904
201905
201906
201907
201908
201909
201910
201911
201912

[Taoufiq_Zarra]

@Raggs 

what is the link between input and output?

how do you get 201901 -> 201912 from both dates :

01-01-2019

01-09-2019

[Kushal_Chawda]

@Raggs  try below

Date(floor(MD_FromDate),'YYYYMM') as MD_FDate_YYYYMM

[Raggs]

Hello Taoufiq, 

there is no link, we have the date values like this and need to get the entire months for year.

[Raggs]

This is working and getting the values as below only 

201901

201909

 but, we need it to entire year

[Brett_Bleess]

Some Design Blog posts that may be helpful:

https://community.qlik.com/t5/Qlik-Design-Blog/Why-don-t-my-dates-work/ba-p/1465849

https://community.qlik.com/t5/Qlik-Design-Blog/The-Date-Function/ba-p/1463157

Regards,
Brett