Converting Date in Load Editor

[Newbie_To_Qlik]

Hello

I had the following date format and would like to add consumeMonth (Mar, Feb, Jan etc) and ConsumeYear (2021, 2020) in load editor. How can I do it

I had tried using the following but there is no data for consumeMonth and ConsumeYear.

Year ("Consume Date") as ConsumeYear,
Month("Consume Date") as ConsumeMonth,

Anyone can help

Consume Date	Consume Month	Consume Year
27 Mar 2021
27 Mar 2021
26 Mar 2021
26-Feb-21
25-Feb-21
25-Feb-21
24-Jan-21
24-Jan-21
24-Jan-21
24-Dec-20
24-Dec-20
24-Dec-20

[Chanty4u · Accepted solution]

try this

Alt(Date(floor([ConsumeDate]),'DD-MMM-YYYY'),Date(Date#([ConsumeDate],'DD MMM YYYY'),'DD-MMM-YYYY'))  as new date. 

year(consumedate) as Year

month(consumedate) as month