Date Format for OWC/Pivot Table

[dldev]

Hello, I am currently returning the date from an Cube Dimension into an OWC Pivot Table as such:
2008-01-30 00:00:00

I have been researching how to apply a short date format (mm/dd/yyyy) on the web page as such:

RowAxis.InsertFieldSet(FieldSets("Request Open Date")).NumberFormat = "Short Date";

But this does not work, and the cube dimension was set-up in such a way as I cannot create a calculated member for this. This field needs to be on the RowAxis only anyway.

Could someone please suggest an alternative or something I haven't discovered that would enable me to apply the short date format to this field in the pivot table? I am stumped at this point.

Thanks in advance,
Dennis

 

[jmeckley]

MSDN String Formatting

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[dldev]

Thanks, but this doesn't help me. I'm trying to do this on an .htm page used by the OWC component.

 

[ca8msm]

I'm trying to do this on an .htm page

This isn't an ASP.NET question then if you are just using a .htm file. Try asking in one of the client side forums such as the HTML or javascript ones.


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[dldev]

Actually, you can have asp (vbscript) snippets in an .htm file. But that's OK, I figured it out. In the member name column in the Dimension Editor:

CONVERT(CHAR(10),"dbo"."date_dim"."the_date",103)

Thanks everyone for your GREAT help!

 

[jmeckley]

Actually, you can have asp (vbscript) snippets in an .htm file

yes, you can. however that's not asp.net which is what this forum is for.

Jason Meckley
Programmer
Specialty Bakers, Inc.

 

[ca8msm]

And vbscript isn't the same as asp either (hence why there are seperate forums for each one) so whichever language you are using I'd suggest searching for the appropiate forum.


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[dldev]

Thanks for all of your great advice Jason.