Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DATEDIFF

Hello,  I want to get date different but the answer is wrong. I try to change format of contact date vaule but it is not working.  Pleae refer to below for detial.    ===  ======= Recency = I...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , try like

    Recency =
IF(ISBLANK(Trans[CUSTNUM1]), BLANK(),DATEDIFF(date(2015,01,01),Trans[Last Visit Date],DAY))
amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , try like

Recency =
IF(ISBLANK(Trans[CUSTNUM1]), BLANK(),DATEDIFF(date(2015,01,01),Trans[Last Visit Date],DAY))