topic Derive MonthYear from Date in QlikView

Derive MonthYear from Date

shamitshah — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have the following to derive the date, which is working fine:

Date(Date#([FY KPI], 'DD-MM-YYYY')) as FYKPIDate

I tried the following to derive the monthyear but it does not seem to work:

Date(MonthStart(Date#([FY KPI])), 'MMM-YY') as FYKPIMonthYear

Any ideas?

Thanks

Shamit

tamilarasu — Sat, 30 Jul 2016 07:22:24 GMT

Hi Shamit,

Date(Date#([FY KPI], 'DD-MM-YYYY'),'MMM-YY') as FYKPIMonthYear

maxgro — Sat, 30 Jul 2016 07:28:38 GMT

Date(MonthStart(Date#(yourfieldhere, 'DD-MM-YYYY')), 'MM-YYYY') as FYKPIMonthYear

shamitshah — Sat, 30 Jul 2016 07:30:26 GMT

Hi Tamil,

That does not seem to work either.

I also tried

Date(Date#([FY KPI], 'MMM-YYYY'))

Thanks

Shamit

shamitshah — Sat, 30 Jul 2016 07:33:55 GMT

Thanks Maxgro!

Works perfectly.

Shamit

Anil_Babu_Samineni — Sat, 30 Jul 2016 07:37:24 GMT

How about this

date(monthstart(yourfieldyear), 'MMM-YYYY') as FYKPIMonthYear

maxgro — Sat, 30 Jul 2016 07:37:46 GMT

further explanation about the dates

tamilarasu — Sat, 30 Jul 2016 08:04:00 GMT

Hi Shamit,

You should read below blog post to understand the difference between Date() and Date#() function.