Skip to Content
0
Former Member
Mar 17, 2009 at 01:38 PM

Formatting date

27 Views

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