Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shamitshah
Partner - Creator
Partner - Creator

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
Champion
Champion

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

shamitshah
Partner - Creator
Partner - Creator
Author

Hi Tamil,

That does not seem to work either.

I also tried

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

Thanks

Shamit

shamitshah
Partner - Creator
Partner - Creator
Author

Thanks Maxgro!

Works perfectly.

Shamit

Anil_Babu_Samineni

How about this

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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
Champion
Champion

Hi Shamit,

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

The Date Function