Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Date(MonthStart(Date#(yourfieldhere, 'DD-MM-YYYY')), 'MM-YYYY') as FYKPIMonthYear
Hi Shamit,
Date(Date#([FY KPI], 'DD-MM-YYYY'),'MMM-YY') as FYKPIMonthYear
Date(MonthStart(Date#(yourfieldhere, 'DD-MM-YYYY')), 'MM-YYYY') as FYKPIMonthYear
Hi Tamil,
That does not seem to work either.
I also tried
Date(Date#([FY KPI], 'MMM-YYYY'))
Thanks
Shamit
Thanks Maxgro!
Works perfectly.
Shamit
How about this
date(monthstart(yourfieldyear), 'MMM-YYYY') as FYKPIMonthYear
Hi Shamit,
You should read below blog post to understand the difference between Date() and Date#() function.