Getting MonthName from timestamp

Sun, 07 Jul 2013 15:35:22 GMT

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

Re: Getting MonthName from timestamp

swuehl — Sun, 07 Jul 2013 15:58:40 GMT

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'))

topic Getting MonthName from timestamp in QlikView

Getting MonthName from timestamp

Re: Getting MonthName from timestamp