Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Getting MonthName from timestamp

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

1 Reply
swuehl
MVP
MVP

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