Number of days (current date-goods receipt date)

Hi All,

I have a requirement like this :

need to display no of days in Query which is CKF=current date-GR date. GR date is coming from r/3.We do not have current date field. and moreover no of days is in the selection screen.So we should have no of days calculated already in the cube.am i rght? calculation shold be done before data comes into the cube i.e in transfer rules or update rules...thats what i thought.Am i rght? can anybody come up with some code to calculte no of days in transfer rules or update rules?

pl correct me if i am wrong.

regards

Message was edited by: cmd