Getting MonthName from timestamp

[#1]

Hi there,

I'm kind of new and have the following problem:

In my original csv, there are timestamps in this format: 2013-04-13 15:45:58 +0200

I would like to use the MonthName and YearName function but Qlikview doesn't recognize the timestamp as a timestamp. So even if I put in the MonthName function around the date, it returns the complete timestamp.

What can I do to be able to use the monthname and yearname formulas, thus making the usability of the sheet a lot easier.

PS: not sure whether this info is relevant, but in the script editor, the timestamp is set as: SET TimestampFormat='YYY-MM-DD hh:mm:ss +TTTT';

Thanks a lot for any help! Best,

Steffen

[swuehl]

Steffen, you are missing a Y in your Timestamp Format and TT is using AM/PM notation, not timezone.

So maybe try like this:

Monthname( timestamp#( left('2013-04-13 15:45:58 +0200',18),'YYYY-MM-DD hh:mm:ss'))

or just

=Monthname( timestamp#( left('2013-04-13 15:45:58 +0200',7),'YYYY-MM'))