Derive MonthYear from Date

[shamitshah]

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]

Hi Shamit,

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

[maxgro · Accepted solution]

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

[shamitshah]

Hi Tamil,

That does not seem to work either.

I also tried

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

Thanks

Shamit

[shamitshah]

Thanks Maxgro!

Works perfectly.

Shamit

[Anil_Babu_Samineni]

How about this

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

[maxgro]

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