In the rpd, I have a condition where
If (received_date- current_date) < X then ....
the received date in the database is numeric. Ex : 20040810
How do I change the date format to match the default current date in the expression builder.
Looks like you are using this calculations based on fact table or might be physical columns.
I would suggest to use logical columns so that you can use the date(for received_date) column your day dim.
map the day dim to fact table and use physical expression for the same, its same as your other post with status=completed as I said in my last email.
You have to use timestampdiff function.
If helps mark
Edited by: Srini VEERAVALLI on Feb 20, 2013 2:47 PM