Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
shamitshah
Partner
Partner

Derive MonthYear from Date

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

1 Solution

Accepted Solutions
maxgro
MVP
MVP

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

View solution in original post

7 Replies
tamilarasu

Hi Shamit,

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

maxgro
MVP
MVP

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

View solution in original post

shamitshah
Partner
Partner
Author

Hi Tamil,

That does not seem to work either.

I also tried

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

Thanks

Shamit

shamitshah
Partner
Partner
Author

Thanks Maxgro!

Works perfectly.

Shamit

Anil_Babu_Samineni

How about this

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
maxgro
MVP
MVP

further explanation about the dates

Get the Dates Right

Why don’t my dates work?

tamilarasu

Hi Shamit,

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

The Date Function