topic Re: How to create a month field from existing date in QlikView

How to create a month field from existing date

Wed, 22 Mar 2017 14:19:36 GMT

How do I set a month value from an existing date value? My data has dates listed as "09 June 2011 11:38:29 EST" All I want is to create a field that would only have the month- "June"

Re: How to create a month field from existing date

swuehl — Wed, 22 Mar 2017 14:25:35 GMT

Maybe like

LOAD

TimestampField,

Text(Date(TimestampField,'MMMM')) as MonthName,

...

You need to ensure that your Timestamp is correctly read in with a numeric representation, please have a look at

Get the Dates Right

Re: How to create a month field from existing date

HirisH_V7 — Wed, 22 Mar 2017 15:14:37 GMT

Hi,

May be use this,

SubField(TimeStamp,' ',2) as Month

if you require complete calendar table means, go with stefans suggestion.

-Hirish

Re: How to create a month field from existing date

Mon, 27 Mar 2017 18:03:34 GMT

This worked,but how would I add the year to it? like June 2017

Re: How to create a month field from existing date

swuehl — Mon, 27 Mar 2017 18:13:56 GMT

Maybe

Date(Monthstart(TimestampField),'MMMM YYYY') as MonthYear,