Month format

[dunnalahk123]

Hi ,

Can some one help me with my month Format

In my month Filter i am getting values as per below snapshot

like 43252 but i need everything should be like "201711" format

This is happening because when i source data from different Sources for different KPI's few of the KPI's month is coming like 43252 etc. but i need my month filter with values like 201711 foramt

[Channa]

while loading just add Date(Month) it will convert number to date later you can define format 'YYYY-MM' or YYYYMM

[pradosh_thakur]

if(len(Month)=6,date(date#(text(Month),'YYYYMM'),'YYYYMM'), DATE(Month,'YYYYMM'))

Please don't duplicate thread.