At the user's request, I have created a key figure with date type "date". The purpose of this is to allowed the user can input the date for each of the material displayed at the BPS layout.
when I use the listcube to display the date key figure, I notice that it is not display as the regular date instead it has benn converted to a number for example 01/12/2005 is dispaly as 731,959. when I delete the date from the layout and save it,now the cube has add a 731,959- record. this is comply with how the infocube deal with ket figure data.
There should be an function which convert the date 01/10/2005 to 731.595 in the BPS back end, anybody know the function name.