This discussion is archived
1 Reply Latest reply: Feb 20, 2013 12:47 PM by Srini VEERAVALLI RSS

Date format in the RPD

960225 Newbie
Currently Being Moderated
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.

Thanks
Avinash
  • 1. Re: Date format in the RPD
    Srini VEERAVALLI Guru
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points