Skip to Content
0

CALDAY and CALMONTH as date field

Jan 04 at 11:03 AM

53

avatar image

HI All,

I have a chart in my design studio application which shows data for all days in the month.

So the date field is DD/MM/YYYY.

User wants to see only DD/MM. Can this be done in design studio. Not sure if the CALDAY object from the BW be adjusted to show only DD/MM as it may be used in many other applications.

Thanks

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Tammy Powlas
Jan 04 at 11:08 AM
0

I would add 0CALMONTH to the BEx Query and then show it in Design Studio

In Lumira Desktop (where you tagged your question) you could use the date/time hierarchy; personally I like to make these types of "transformations" on the back end of query; your application will run faster

Share
10 |10000 characters needed characters left characters exceeded