Hi,
From a BI Query I receive a date which is displayed in a table. In the table the date is displayed as follows:
01.03.2008 31.12.2008
I want it to be displayed as March 01, 2008 and December 12, 2008.
I have used the following formula in the custom text formatting of the cell of the table:
DSTR(@Actual_Date_to_ext_key,"MON DD, YYYY")
Strangely the date is now displayed as
jan 03, 2008 Jul 12, 2008
What am I doing wrong? BTW: The field in the table isof data type text and I can not change it to Date. I have already tried to add a new field with data type date, but it doesn't display the date delivered by the query.
Thanks in advance for your help and best regards,
Jan Laros