1 Reply Latest reply on Feb 20, 2013 8:47 PM by SriniVEERAVALLI

    Date format in the RPD

      Hi gurus,
      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.

        • 1. Re: Date format in the RPD
          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.
          or else
          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