Trim a part of field and transform to date

[IgorGol]

Hi,

I have one columns with this kind of rows :

1. January-Planning

2. January-Actual

3. February-Planning

4. February-Actual

How would you:

1. Separate the word before '-' Delimiter  (January for example)

2. The word from 1 (January) how would you transform to date? so qlik will now it is Month and not a Text

Thanks!

[mfarsln · Accepted solution]

Hi,

For the first requirement;

mid(MonthField,1,index(MonthField,'-')-1)

Second one;

MakeDate(2020, Month(Date#(mid(MonthField,1,index(MonthField,'-')-1),'MMMM')),01 )

Oh you just wanted it as month, not date. So you can just use "Month(Date#(mid(MonthField,1,index(MonthField,'-')-1),'MMMM'))".

[IgorGol]

Thanks,

A lot