Forum Discussion

PatriceGREN's avatar
PatriceGREN
Regular Visitor
7 years ago
Solved

Using Dateadd

Hi,  I can t use the DATEADD function correctly. DATEADD(HISTORIQUE[DateFinPeriodeEssai1],-nbjprevenance,DAY) -nbjprevenance = variable  if I put 0 in place of the variable, I get the right dates...
Need Help
  • PatriceGREN's avatar
    PatriceGREN
    7 years ago

    Hi,

    After many tests, I tried this syntax:

    HISTORIQUE[DateFinPeriodeEssai1] - nbjprevenance

    and it works.

     

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

PatriceGRENcan you provide details on how you are calculating nbjprevenance variable? Also do you have date dimension in your model on which you are performing this DateADD function?

PatriceGREN's avatar
PatriceGREN
Regular Visitor
7 years ago

  • PatriceGREN's avatar
    PatriceGREN
    Regular Visitor
    7 years ago

    Hi,

    After many tests, I tried this syntax:

    HISTORIQUE[DateFinPeriodeEssai1] - nbjprevenance

    and it works.