Skip to Content
0
Former Member
Apr 13, 2005 at 07:07 PM

Date convertion function in BPS layout

35 Views

Hi,

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.

Thanks,