Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

month name from textfield

Hello,

I am trying a lot but I dont get it to work. Hopefully someone can help me.

I have a textfield with "Transaction Fees "&Monthname&Year

I want to take the monthname and Year from this field into a new field and convert it to a date.

How can I do this?

Very much thanks for your help in advance.

Chris

1 Solution

Accepted Solutions
sunny_talwar

I think your environmental variable is in another language which is why MMMM is unable to recoginze them as months...

SET LongMonthNames='Januar;Februar;März;April;Mai;Juni;Juli;August;September;Oktober;November;Dezember';

Try this

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

View solution in original post

10 Replies
sunny_talwar

May be try this

Date(Date#(PurgeChar(SubField(FieldName, 'Transaction Fees ', -1), ' '), 'MMMYYYY')) as Date

Anonymous
Not applicable
Author

Hello Sunny,

thank you very much. I think it helped.But only May-Months are shown correctly.

Is it possible, that this has to do with the blanks after the monthname?

I have no idea how much blanks are there.

You have an idea of a solution?

sunny_talwar

My bad.. I missed the extra M

Date(Date#(PurgeChar(SubField(FieldName, 'Transaction Fees ', -1), ' '), 'MMMMYYYY')) as Date

Anonymous
Not applicable
Author

Hello Sunny,

it unfortunately did not work. Would you please have a look?

it is in Adyen SettlementReport Line 36

sunny_talwar

Which tab am I looking at?

Anonymous
Not applicable
Author

it is in script in Tab Adyen SettlementReport (line 36)

sunny_talwar

I think your environmental variable is in another language which is why MMMM is unable to recoginze them as months...

SET LongMonthNames='Januar;Februar;März;April;Mai;Juni;Juli;August;September;Oktober;November;Dezember';

Try this

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

Anonymous
Not applicable
Author

now it worked for june and july.

is it possible to eliminate the blanks between month name and year.

for every monthname they are different 😞

sunny_talwar

That is what PurgeChar is doing... removing the spaces between Monthname and Year