How to get YearMonth field from a timestamp

[#1]

Hi I have a normal time field with date and time. i use

date(floor([Execution Date]),'MMM-YYYY') AS yearmonth

to get the yearmonth. but i still can't aggregate based on that. because I notice in the list box, they show multiple same yearmonth, so the date is still there. how to get rid of date from my yearmonth so that i can calculate based on that. see the pic

I guess it is a simple question... maybe it is my way of search but i have not find answers in the forum.

Thanks for the help!

[#2]

Hi ,

Try the below in your load script:

MonthName(Execution Date) as YearMonth

Thanks,

Shekar!!

[sorrakis01]

Hi,

Monthname(date) or

Year(date) & '-' & Month(date)

Regards

[#4]

Geez...Just so many functions even for date lol thanks man!

[maximiliano_vel]

Try this

=Dual(Text(Date([Execution Date], 'MMM-YYYY')), Num#(Text(Date([Execution Date], 'YYYYMM'))))

[maxgro]

another way: format as MMM-YYYY the start date of the month

date(floor(MonthStart([Execution Date])), 'MMM-YYYY') as yearmonth

[qlikviewwizard]

Hi Please use this.

SET DateFormat='MMM-YYYY';

Load  date ([Execution Date]) as [Execution Date] INLINE [

Execution Date

JAN-2015

FEB-2015

MAR-2015

];

Hope this will help you.

How to get YearMonth field from a timestamp