Date Format Mmm 'yy

building reports webintelligence
1

Hello There,

I have date objects in the universe (dd/mm/yyyy) , User want to display it in the Mmm 'yy (Ex: Oct '14)

I have tried format date and custom format(giving Invalid template error) , but no luck.

Thanks in Advance.
Shravan R.

shravan_bo :india: (BOB member since 2006-04-25)

2

In 4.1SP3 this works for me:

=FormatDate([Date];"Mmm ''yy")

In front of yy there are two single ’
Though it looks like there’s a space between them, in real there isn’t.

MBLM :netherlands: (BOB member since 2014-01-31)

3

Hi,

Thank you very much , it is working. But Date order has missing.
Earlier it was calender order format. Now it is coming Ascending order after applying the FormatDate.

Thanks&Regards,
Shravan R.

shravan_bo :india: (BOB member since 2006-04-25)

4

That’s because FormatDate() returns a string. Your options would be to either go back and try to solve the custom format issue again (that invalid template error is weird), or add the date as a hidden column that you sort on.

Lugh (BOB member since 2009-07-16)

5

Hey,
I was having a similar problem.
In my case I have got amounts corresponding to date.
But when I aggregated amounts as sum for date format “Mmm-yy” and then added date column and hid it, it is no longer available in aggregated form.

Nilesh Mishra :india: (BOB member since 2017-07-11)