Showing results for 
Search instead for 
Did you mean: 

CALDAY and CALMONTH as date field

0 Kudos

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.


Accepted Solutions (0)

Answers (1)

Answers (1)

Active Contributor
0 Kudos

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